Thursday, 11 April 2013

Data Sheet as per the Questions being asked

Which is the most played Slot Machine ?



 Using the "Slot machine type"and"Slot coin in" metrics we will be able to determine how many people play each machine. If it's a 25 cent operated machine we would divide the Slot coin in metric by that amount. To find out what machine is being played we will use the "Slot machine game" metric.



What machine makes/losses the most money?




To figure out what machines are most and leaste profitable we will use the "Slot jackpot amount", "Slot payout amount", "Slot win"metrics.
We have used the least Coin In arranged in Ranking from Lowest amt to Highest amt and also include the Jackpot Amt which is calculated in percentage to the total the Jackpot Amt.





Which is the best location to have the slot machine 


We will be looking at the"Slot location"and "Slot zone"metric to to determine where the machines are located and find out if there is any correlation with that and profits. 




Which Year had the Highest Jackpot


The "Year" metric and "Slot Jackpot Amount" will be used to determine the which year has the highest jackpot. 


Affects on profitability due to Weather Conditions


For this question we will use the "Weather" metric to provide insight on what days each machine was used in sunny conditions and see if it correlates with the most profitable machines.