Excel File Edit View Insert Format Tools Data Window Help $ ? ) 53% [+ Wed 9:59 PM Q E ... AutoSave O OFF AHULENNOR - 1cost data_summer_2020_ - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Chart Design Format Tell me Share Comments Le From HTML V La Connections 1x Clear J. Sort Filter Reapply Flash Fill Group La From Text Properties Data Validation v Refresh Text to Ungroup v New Database Query v Edit Links Stocks Geogra Advanced Ex Remove Duplicates - Consolidate What-If Subtotal Analysis Data Solver All Columns Analysis Tools Analysis Chart 2 4 X V fic B C D E F G H K L M N 0 P Q R S T SUMMARY OUTPUT Regression Statistics 4 Quantity Line Fit Plot Multiple R 0.43508542 5 R Square 0.18929932 600.00 6 Adjusted R Sq 0.17834391 400.00 Standard Erro 33.3038671 200.00 * Average Cost 8 Observations 151 Average Cost 0.00 Predicted Average Cost 10 ANOVA -200.00 0.00 5.00 10.00 15.00 20.00 25.00 11 df SS MS F Significance F Quantity 12 Regression 2 38330.0663 19165.0332 17.2790653 1.80178-07 13 Residual 148 164153.839 1109.14756 14 Tota 150 202483.906 Quantity Squared Line Fit Plot 15 Coefficients itandard Error 600.00 16 t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 17 Intercept 58.9576426 8.0814494 7.29542929 1.6762E-11 42.9877087 74.9275766 42.9877087 74.9275766 400.00 18 Quantity -8.8426707 1.65205261 -5.3525358 3.2377E-07 -12.107329 -5.5780124 -12.107329 -5.5780124 Average Cost 200.00 * Average Cost 19 Quantity Sque 0.3236554 0.07079368 4.57181182 1.0134E-05 0.18375841 0.46355239 0.18375841 0.46355239 0.00 Predicted Average Cost 20 -200.00 3 100 150 200 21 Quantity Squared 22 23 RESIDUAL OUTPUT 24 25 Observation icted Average Residuals 26 1 31.2779336 -18.373017 27 2 11.711621 -2.7575308 28 3 27.2080159 -15.597072 29 4 49.7044873 -22.506405 30 5 -0.308241 7.21253134 Regression Cost data + + 100% JUN 17 X W