Purchase Solution

Correlation and Regression applied to a dataset in Excel

Not what you're looking for?

Ask Custom Question

Please take the data I provide and do the computations and graphing for me, then explain the results to me so that I can write a paper and give a presentation on it.

Here is my assignment:

Prepare a 1,000 - 1,500 word paper applying Regression and Correlation to a personal or business application the student is familiar with. The paper requires the original collection of interval or ratio level data that appears to be correlated. Utilizing the Regression function and graphing function in Excel, the student is required to compute the mean, median and mode for both sets of data, and the calculation and interpretation of the coefficient of correlation, coefficient of determination. In addition, the student must use the graphing function to graph the data and compute the regression equation. Once all of these numbers are calculated, the student must interpret the meaning of all the numbers.

Let me repeat- I can write the paper, but I need all of the pre-work done, with an explanation on the numbers/results...

I am attaching info on alcohol related car crashes...There are two sets of data, both do not have to be used; I added the gender-releated information in case we needed more data. Thanks!

Attachments
Purchase this Solution
Solution Summary

Correlation and Regression applied to a dataset of alcohol-related crash history implemented in Excel with explanation.

Purchase this Solution
Free BrainMass Quizzes
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

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

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Correlation & Regression

    297687 Statistics Module: Correlation and Regression Module 6: Correlation and Regression A For the supermodel dataset at the right, treat height as the explanatory variable and weight as the response variable.

  • Job Satisfaction-Statistical Survey and Regression Anaylsis

    295012 Job Satisfaction - A Statistical Survey and Regression Anaylsis in EXCEL See attached data set. Prepare a report using Excel as your processing tool to process three simple regression analyses.

  • Correlation Matrix and Regression Analysis

    547972 Correlation Matrix and Regression Analysis Conduct a correlation matrix using the Forbes 500 dataset. Determine which variables have a significant relationship. Select an independent and dependent variables and run a regression analysis.

  • File SAS and conduct a multiple linear regression analysis

    The following steps are necessary to complete this assignment: 1. Read an Excel file into SAS and list the contents of the SAS dataset (Use Proc Contents). Note that there are no missing values in the dataset. 2.

  • Regression Analysis

    The solution includes analyses in an Excel worksheet and a discussion of the results in a Word document.

  • Relationship: Correlations and Regressions

    Excel was used for Correlations and Regression analysis.

  • Regression Analysis

    The coefficient of determination gives the proportion of variability in a dataset that can be explained by the regression model. Thus, the proportion of variability in the given dataset that can be explained by this regression model is 0.83313.

  • Discussion: Correlation and Bivariate Regression

    630752 Discussion: Correlation and Bivariate Regression This Solution works with a real, secondary dataset to construct a research question, perform a correlation and bivariate regression model, and interpret the results.

  • Using Excel as your processing tool

    The analysis can be found in the regression.doc, while the Excel spreadsheets can be found in the .xls. The solution uses excel to perform a regression analysis on data.

View More Related Solutions