Assignment
Each question is worth ten points. Please use additional paper if you need to while answering these questions. Please use the Thread City Café Project Excel spreadsheet to answer the following questions:
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?
10. What else can you say about these data?
|
Thread City Café Daily Report
|
|
|
|
|
|
|
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
|