Question

In: Statistics and Probability

1) What is the average daily sales for the month? 2) What is the average daily...

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

Solutions

Expert Solution


Related Solutions

PLEASE DO BY HAND AND NOT EXCEL 1.A car dealer believes that average daily sales for...
PLEASE DO BY HAND AND NOT EXCEL 1.A car dealer believes that average daily sales for four different dealerships in four separate states are equal. A random sample of days results in the following data on daily sales: Ohio                New York       West Virginia              Pennsylvania                3                          10                         3                                  20                2                            0                         4                                  11                6                            7                         5                                  8                4                            8                                                             2                4                            0                                                             14                7...
find the annual credit sales for a firm with an average daily investment in receivable and...
find the annual credit sales for a firm with an average daily investment in receivable and collection period 69723 and 31.4 days respectively?
The manager of a store would like to know if the average daily sales (measured in...
The manager of a store would like to know if the average daily sales (measured in dollars) through her website are any different than her in-store sales. The data has been collected on 51 days on website and in store. Perform an analysis at 5% significance level. Start by stating the hypothesis. Online In-Store 805.45 1400.76 780.27 969.27 927.79 1049.61 812.86 1453.6 550.91 876.72 901.07 1119.49 869.76 976.6 867.17 1017.76 801.91 482.12 973.15 1149.21 746.65 809.37 980.25 968.43 892.53 1077.45...
A hotel chain wants to estimate the average number of rooms rented daily in each month....
A hotel chain wants to estimate the average number of rooms rented daily in each month. The population of rooms rented daily is assumed to be normally distributed for each month with a standard deviation of 24 rooms. During January, a sample of 16 days has a sample mean of 48 rooms. This information is used to calculate an interval estimate for the population mean to be from 40 to 56 rooms. What is the level of confidence of this...
A local electronics firm wants to determine their average daily sales (in dollars.) A sample of...
A local electronics firm wants to determine their average daily sales (in dollars.) A sample of the sales for 36 days revealed an average sales of $141,000. Assume that the standard deviation of the population is known to be $12,000. Then, the 95% margin of error will be . . . Provide a 95% confidence interval estimate for the true average daily sales. $137,080 to $144,920 $139,500 to $143,000 $132,800 to 139,200 $136,200 to $142,200 $140,600 to $143,200 $135,600 to...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake of Americans compared to the daily recommended dietary allowance (inadequate, meet/achieve, excessive)? 2. a. What factors contribute to causing American’s dietary intake to be this way? b. Consider factors related to health, agriculture, food access/availability, socioeconomic status, etc. 3. a. Are certain groups/populations at increased risk of consuming an inadequate protein intake? b. Consider reasons related to increased protein requirements, poor access, ethical reasons,...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake of Americans compared to the daily recommended dietary allowance (inadequate, meet/achieve, excessive)? 2. a. What factors contribute to causing American’s dietary intake to be this way? b. Consider factors related to health, agriculture, food access/availability, socioeconomic status, etc. 3. a. Are certain groups/populations at increased risk of consuming an inadequate protein intake? b. Consider reasons related to increased protein requirements, poor access, ethical reasons,...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake of Americans compared to the daily recommended dietary allowance (inadequate, meet/achieve, excessive)? 2. a. What factors contribute to causing American’s dietary intake to be this way? b. Consider factors related to health, agriculture, food access/availability, socioeconomic status, etc. 3. a. Are certain groups/populations at increased risk of consuming an inadequate protein intake? b. Consider reasons related to increased protein requirements, poor access, ethical reasons,...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake...
Dietary Protein Intake in the U.S.   1. On average, what is the daily dietary protein intake of Americans compared to the daily recommended dietary allowance (inadequate, meet/achieve, excessive)? 2. a. What factors contribute to causing American’s dietary intake to be this way? b. Consider factors related to health, agriculture, food access/availability, socioeconomic status, etc. 3. a. Are certain groups/populations at increased risk of consuming an inadequate protein intake? b. Consider reasons related to increased protein requirements, poor access, ethical reasons,...
A small stock brokerage firm wants to determine the average daily sales (in dollars) of stocks...
A small stock brokerage firm wants to determine the average daily sales (in dollars) of stocks to their clients. A sample of the sales for 30 days revealed an average daily sales of $200,000. Assume that the standard deviation of the population is known to be $20,000. 8. Provide a 90% confidence interval estimate for the true average daily sales. 9. Provide a 97% confidence interval estimate for the true average daily sales.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT