Project #10452 - Statistics EXCEL 06

Correlation, Regression, Scatterplots


As we proceed through the course, the intention is for you to learn to use statistics to answer real world questions. The attached spreadsheet contains questions for you to solve using the statistical tools of correlation and regression. To get the correlation between 2 variables, the 2 variables are ordered pairs, with an explanatory (independent) variable and the response (dependent) variable, which correspond to the x- and y-axis respectively.

In Excel, the CORREL function will return correlation ranging from -1 to +1, where values close to -1 mean the 2 variables are strongly correlated in opposing direction, values close to +1 mean the 2 variables are strongly correlated in same direction, and values close to 0 mean the 2 variables have no correlation to each other. The textbook provides more information on interpretation of intermediate values. 

Command format is:  =CORREL(array1,array2).

To obtain a regression line and equation, you will need to make a scatterplot without connecting lines, and then add a trendline to the data series. The explanatory variable should be the x-axis, which will allow you to use the equation to make predictions. Be sure to check the box to display the equation. Data, graphs, calculations, and written analysis should complement each other in determining the overall solution to questions posed.

Subject Mathematics
Due By (Pacific Time) 08/09/2013 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy