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.

**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.

See attached excel file with 4 problems.

Subject | Mathematics |

Due By (Pacific Time) | 04/13/2014 08:00 pm |

Tutor | Rating |
---|---|

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.. |