Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a sample of 116 weekly sales of Tropicana oranges juice, prices of Tropicana, Minute Made, AutoSave OFF 3 Tropicana Data Home Insert Draw

This is a sample of 116 weekly sales of Tropicana oranges juice, prices of Tropicana, Minute Made,

image text in transcribed
AutoSave OFF 3 Tropicana Data Home Insert Draw Page Layout Formulas Data Review View ? Tell me Arial 10 " A" A" aB % Conditional Formatting Format as Table Paste BIU Y AVAv Number Cell Styles v Cells Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? J6 + X V fx A B C D E F G H I J K L M SUMMARY OUTPUT Regression Statistics 4 Multiple R 0.818424409 5 R Square 69818514 6 Adjusted R Square 54810265 7 Standard Error 11811.44376 B Observations 116 9 10 ANOVA 11 SS MS ignificance F 12 Regression 5 31131717954 6.23E+09 44.63002 5.99E-25 13 Residual 110 15346122395 1.48+08 14 Total 115 46477840349 15 16 Coefficients Standard Error Stat P-value Lower 95% Upper 95% ower 95.09/pper 95.0% 7 Intercept 54434.01686 10151.90119 5.361953 4.59E-07 34315.33 74552.7 34315.33 74552.7 18 Price Trop -21274.83138 2606.694783 -8.16161 5.97E-13 -26440.7 -16109 -26440.7 -16109 19 Price MM 8796.880907 2830.093242 3.108336 0.002395 3188.3 14405.46 3188.3 14405.46 20 Price Dom 898.2071683 3047.525898 0.294733 0.768753 -5141.27 6937.688 -5141.27 6937.688 21 Feature 938.3844498 2644.852137 0.354797 0.723421 -4303.09 6179.861 -4303.09 6179.861 22 Display 19576.16684 3195.870786 6.125456 1.43E-08 1 13242.7 25909.63 13242.7 25909.63 23 24 25 26 27 28 29 30 31 32 33 34 Sheet1 TropicanaData +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The law of marketing

Authors: Lynda J. Oswald

2nd Edition

2901439079248, 1439079242, 978-1439079249

More Books

Students also viewed these Marketing questions