quant (heavy excel)

Analyzing an Advertising Sales Dataset

Use this Kaggle dataset for this assignment

https://www.kaggle.com/datasets/yasserh/advertising-sales-dataset

Perform a Multiple Regression Analysis using the interval level or above variables in the dataset for this week. Sales is to be used as the Response Variable.

Neatness and APA style formatting is expected throughout.  11 pt font or larger. Copy and paste prompts into your submission document. Submit in PDF format only. DO NOT SUBMIT EXCEL or JASP DATASETS OR R script.  Feel free to use either JASP or Excel to generate evidences.

1) Report your COMPLETED Exploratory Analysis report. That should include numerical and chart generation and interpretations, for all interval / ratio level variables in the dataset.  Much of this you already created when completing HW 1

2) In Excel or JASP, Run the multiple regression and report the 3 regression output tables. Interpret the relevant statistics (Multiple R, Adjusted R Squared, Significance F, p-values for explanatory variables)

3) After running the regression test in #2 above, perform an assumptions check by generating the residuals in Excel or JASP (generate histogram of the residuals) , generate a residual plot (residuals vs predicted) and interpret the results

CustomEssayMasters

Ready To Get Started

The Exertio is a Premium WordPress Theme, you can create your own market place website using this theme. It allows you to get a commission for hiring a freelancer or for each service sold.