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.
This response includes various descriptive statistics that are calculated from a data set. A small sample t test is performed and a simple linear regression analysis is conducted using Excel.