Question

Chapter 9 s) John is the manager of the local Wall Red Variety store. He has taken a random sample of seven business days from the last several months to get the data in the table below X-total number of people in the store (in hundreds) and y-total days receipts (in thousands of dollars) x S.s 61 3.2 24 7.5 8.1 4.4 Y 126 13.4 7.6 5.8 15.9 17.0 9.7 a)Calculate ?, ?y, ??33/Exy 25points C) calculate?e ometon coffiant. r. Sate near recc data fron) te sample state all rssoy 0 least square line pred dos the r the total sales?

Answer 1

Book1 Excel (Product Activation Failed) CHART TOOLS FILE à From Access From Welb From Text Sources Connections All- HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW DESIGN FORMAT vinit gupta Lal Connections Clear From Other Existing Refresh Sort Filter Reapply Text to Flash Remove Data Consolidate What-If Relationships Group Ungroup Subtotal Columnsl Duplicates Validation Edit Links Get External Data Connections Sort &Filter Data Tools Outline Anaysis Chart 1 0 8 Observati 10 ANOVA 0.2 MS iicance F 5.8 12 Regressio 13 Residual 14 Total 1 104.6696 104.6696 1817.424 1.81E-06 4 0.230369 0.057592 104.9 Normal Probability Plot 5.8 Line Fit Plot Coefficientan dard Err t Stat P-value Lower 95%Upper 95%ower 95.09 pper 95.0% 17 Intercept 1.187563 0.263161 4.512677 0.010718 0.456909 1.918216 0.456909 1.918216 5.8 1.970808 0.046229 42.63125 1.81E-06 1.842456 2.099161 1.842456 2.099161 15 Series1 20 Predicted 12 40 22 RESIDUAL OUTPUT PROBABILITY OUTPUT Sample Percentile 24 bservatioredicted 12 Residuals dard Residuals 25 Percentile 12.4 1 13.20949 0.390507 1.819286 2 7.494149 0.105851 0.493136 35.917503 -0.1175-0.54742 4 15.96863 -0.06863-0.31971 5 17.15111 -0.15111 -0.70399 6 9.859119 -0.159120.7413 8.333333 25 41.66667 58.33333 75 91.66667 5.8 T.6 9.7 13.6 15.9 27 Sheet4 Sheet6 Sheet5 Sheet3 AVERAGE: 39.02667983 COUNT: 101 SUM: 2692.840912 + 100% 03:26 O Type here to search sf, ^瘟ロ脈ENG 20-05-2018

Book1 Excel (Product Activation Failed) CHART TOOLS FILE à From Access From Welb HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW DESIGN FORMAT vinit gupta Connections Clear From Other Existing Refresh Sources . Sort Filter Reapply Text to Flash Remove Data Consolidate What-If Relationships Group Ungroup Subtotal Columnsl Duplicates Validation Le From Text Connections All, Edit Links Advanced Get External Data Connections Sort &Filter Data Tools Outline Anaysis Chart 1 0 1 SUMMARY OUTPUT 3 Regression Statistics 4 Multiple F 0.998901 5 R Square 0.997804 6 AdjustedI 0.997255 7 StandardE 0.239984 8 Observati 5.8 Residual Plot 0.6 0.4 0.2 10 ANOVA 0.2 MS ance F 12 Regressio 13 Residual 14 Total 1 104.6696 104.6696 1817.424 1.81E-06 0.230369 0.057592 104.9 Normal Probability Plot 5.8 Line Fit Plot Coefficientandard Err t stat p-value Lower 95%U oer 95%over 95.09 p er 95.0% 17 Intercept 1.187563 0.263161 4.512677 0.010718 0.456909 1.918216 0.456909 1.918216 5.8 1.970808 0.04б229 42.63125 1.81E-06 1.842456 2.099161 1.842456 2.099161 15 10 Series1 20 21 22 RESIDUAL OUTPUT 23 Predicted 12 100 PROBABILITY OUTPUT Sample Percentile 5.8 Sheets Sheet6 Sheets | Sheet3 AVERAGE: 39.02667983 COUNT: 101 SUM: 2692.840912 + 100% 03:26 O Type here to search sf, ^瘟ロ脈ENG 20-05-2018