Question

A manufacturer Doll paperback books in the retail stores and wanted to examine the relationship between price and demand. The price of a particular novel was died each week and the weekly wies were recorded in the accompanying table Management would like to use simple regression analysis to estimate weekly demand for this novel using the price of the novel. What is the sum of quares for his sample ? Click the icon to view the sample sale results for a particular novel OA 4525 Data Table OB 40.16 OG 37.16 OD. 24.17 3 4 6 10 8 10 $12 $11 $10 50 $8 S7 Done

Answer 1

Dear student ,

Sum of squares regression is

option

C. 37.16

some 20sen Page Layout Formulas Data Review View Developer From Access From Web From From Other Text Sources Get External Data Existing Connections Da Connections Properties Refresh All E Edit Links Connections 21 A YA 41 Sort Cle bre Filter Yad Sort & Filter C12 A 37.1571428571429 D E F G H A B 1 SUMMARY OUTPUT 2 3 Regression Statistics 4 Multiple F 0.910376 5 R Square 0.828784 6 Adjusted 0.78598 7 Standard I 1.385297 8 Observati 6 9 10 ANOVA df 11 12 Regressio 13 Residual 14 Total SS MS F gnificance F 1 37.15714| 37.15714 19.36228 0.011689 4 7.67619 1.919048 5 44.83333 15 16 Coefficientandard Err t Stat P-value Lower 95%Upper 95%ower 95.09pper 95.0% 17 Intercept 20.67619 3.196349 6.468691 0.002942 11.8017 29.55068 11.8017 29.55068 18 X Variable -1.45714 0.331149 -4.40026 0.011689 -2.37656 -0.53772 -2.37656 -0.53772 19 20 21 22 23 24 06 Sheet4 Sheets Sheeto Sheet1 Sheet2 Sheet32 Ready Start

Follow the following steps to get answer in excel

1. On the Data tab, in the Analysis group, click the Data Analysis button.
2. Select Regression and click OK.
3. In the Regression dialog box, configure the following settings: Select the Input Y Range, which is your dependent variable. ...
4. Click OK and observe the regression analysis output created by Excel.

Dear student,
I am waiting for your feedback. I have given my 100% to solve your queries. If you are satisfied by my given answer. Can you please like it.
  
Thank You!!!