# Descriptive Statistics, Hypothesis Test, and Linear Regression

I have attached the questions in the document below.

Please only complete task 2a, task 2b and task 3.

For 2a, calculate the following: the mean, mean deviation, standard deviation, median, and mode. The calculations for task 2a have to be for grouped data. This means that you must calculate it per grouped data formulas which look like this formulas example: http://www.emathzone.com/tutorials/basic-statistics/arithmetic-mean.html etc. For task 2a, you must also do the quartiles. The formula is as follows: http://www.emathzone.com/basic-stat/quartiles/clip_image011.gif. Please also create graphs for the calculations and once all calculations are made, give a brief interpretation of the calculations.

For task 2b, please use the following formulas first is this: https://www.uvm.edu/~dhowell/gradstat/psych340/Lectures/Power/Image78.gif and then the test formula following this guideline: http://www.informationr.net/ir/9-2/p173Fig1.jpg

For task 3, the scatter diagram in excel should be "use scatter where x=adv and y=sales" and should look like this: http://dlc.erieri.com/onlinetextbook/images/diagrams/ch15_fig01.gif. In addition to the diagram, the line of regression should be going up.

Â© BrainMass Inc. brainmass.com December 24, 2021, 11:42 pm ad1c9bdddfhttps://brainmass.com/statistics/scatter-plot/descriptive-statistics-hypothesis-test-linear-regression-594244

## SOLUTION This solution is **FREE** courtesy of BrainMass!

I have answered your questions in the attached Word document and the accompanying Excel worksheet. I hope that this helps you understand your material better. Good luck.

Â© BrainMass Inc. brainmass.com December 24, 2021, 11:42 pm ad1c9bdddf>https://brainmass.com/statistics/scatter-plot/descriptive-statistics-hypothesis-test-linear-regression-594244