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 October 17, 2018, 12:54 pm ad1c9bdddf
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.
Descriptive Statistics, Regression Analysis, and Prediction
1) Using the Water use data set (under Course Materials Forum) analyze the data using Excel, MegaStat or whatever statistical software you prefer and report in proper statistical form/jargon about the dataset. (See attached)
2) Using the Water use data set analyze the data using Excel, MegaStat or whatever statistical software you prefer. Perform a proper multiple linear regression analysis and indicate how you are using multiple linear regression to:
Report each in proper statistical form/jargon. You may use any variable as dependent, but water usage is a good one for Y hat.View Full Posting Details