In your write-up: ???? Interpret the scatter plot - What kind of relationship do you see? ???? Interpret the regression output - Is the relationship positive? Statistically significant? ???? Summarize the story for management - Based on your results, should the company continue investing in advertising at this level?

AutoSave on Data Analytics ^NN2 Submission . Saved v Search LB O X File Home Insert Draw Page Layout Formulas Data Review View Automate Help Acrobat Power Pivot Comments Share La From Text/CSV From Picture Queries Connections el Clear Data Analysis Get Lo From Web Lo Recent Sources Refresh Properties Sort Filter 15Reapply Text to Ex What-If Forecast Outline ? Solver Data From Table/Range [a Existing Connections Stocks Currencies All Workbook Links Advanced Columns Analysis Sheet Get Transform Data Queries Connections Data Types Sort Filter Data Tools Forecast Analyze saved to this PC B2 !XV fx v B C D E F G H K M N O P Q R S SUMMARY OUTPUT 1,030,000 3 Regression Statistics 1,025,000 Multiple R 0.535928 R Square 0.287218 1,020,000 Adjusted R Square 0.266254 1,015,000 Revenues Standard Error 6938.735 1,010,000 Revenues Observations 36 ......... Linear ( Revenues ) 1,005,000 10 ANOVA 1,000,000 df SS MS F Significance F Regression 1 659621859.2 659621859.2 13.70043883 0.0007551 995,000 13 Residual 34 1636965319 48146038.79 50,000 51,000 52,000 53,000 54,000 55,000 Total 35 2296587178 Advertising Expense 15 16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 819247.5 51893.25883 15.7871653 3.21959E-17 713787.665 924707.245 713787.6648 924707.2454 18 Advertising Expens 3.677554 0.993554859 3.701410384 0.000755105 1.65840786 5.69670068 1.658407864 5.696700677 19 25