Purchase Solution

Descriptive Statistics, Hypothesis Test, and Linear Regression

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

Solution Summary

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.

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.