Explore BrainMass
Share

# Descriptive Statistics, Hypothesis Test, and Linear Regression

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

I have attached the questions in the document below.

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.