In: Statistics and Probability
1) What is the average daily sales for the month?
2) What is the average daily food cost for the month?
3) What is the average daily employee hours for the month?
4) What is the correlation between daily sales and daily food cost?
5) What is the correlation between daily sales and daily employee hours?
6) Are daily food costs or daily employee hours more correlated with sales? Why do you think this is?
7) What is the Y intercept when X = 0 and the slope of a simple linear regression with daily sales being the independent variable (X) and daily food cost being the dependent variable (Y)?
8) What is the Y intercept when X = 0 and the slope of a simple linear regression with daily sales being the independent variable (X) and daily employee hours being the dependent variable (Y)?
9) Are daily food costs or daily employee hours more correlated with sales when analyzed by day? Why do you think this is?
Day of the Week |
Sales |
Food Cost |
Employee Hours |
Monday |
$800 |
$199.00 |
16 |
Tuesday |
$850 |
$212.50 |
16 |
Wednesday |
$875 |
$218.00 |
16 |
Thursday |
$925 |
$233.00 |
16 |
Friday |
$975 |
$242.00 |
24 |
Saturday |
$1,500 |
$378.00 |
40 |
Sunday |
$2,800 |
$715.00 |
48 |
Monday |
$775 |
$194.00 |
16 |
Tuesday |
$845 |
$208.00 |
16 |
Wednesday |
$874 |
$219.00 |
16 |
Thursday |
$935 |
$234.00 |
16 |
Friday |
$980 |
$248.00 |
24 |
Saturday |
$1,450 |
$363.00 |
40 |
Sunday |
$2,750 |
$688.00 |
48 |
Monday |
$810 |
$205.00 |
16 |
Tuesday |
$848 |
$213.00 |
16 |
Wednesday |
$935 |
$240.00 |
16 |
Thursday |
$940 |
$232.00 |
16 |
Friday |
$985 |
$247.00 |
24 |
Saturday |
$1,525 |
$380.00 |
40 |
Sunday |
$2,850 |
$710.00 |
48 |
Monday |
$825 |
$205.00 |
16 |
Tuesday |
$863 |
$209.00 |
16 |
Wednesday |
$880 |
$219.00 |
16 |
Thursday |
$945 |
$237.00 |
16 |
Friday |
$977 |
$245.00 |
24 |
Saturday |
$1,532 |
$385.00 |
40 |
Sunday |
$2,900 |
$725.00 |
48 |
Total |
$35,149 |
$8,803.50 |
704 |