Business statistics including regression analysis and project management tools

This assignment is an individual assignment.
Your coursework consists of the following three tasks with tasks 1 and 2 based on the results of a survey. Some similar tasks will be performed in seminars with the tutors’ guidance. However, some parts of these tasks will require independent study.
As well as submitting the coursework as a word report for all three tasks you MUST also submit an excel spreadsheet containing the analysis which you have used in your word report.

This document is for Coventry University students for their own use in completing their assessed work for this module and should not be
passed to third parties or posted on any website. Any infringements of this rule should be reported to acreg.fbl@coventry.ac.uk
Assignment Brief

The file “Survey_Data_Sem2.xls” contains the data of an anonymous survey.
Click on the red triangles, within the spreadsheet, to see details of each variable.
The purpose of this report is to:
 Describe the sample
 Investigate whether factors such as gender, type of student and age influence the amount of exercise undertaken in a week.
The report should contain quantitative information, summary statistics and appropriate charts and tables.
The marking scheme is as follows:
 Report Structure and Presentation
o Introduction and summary [5 marks]
o Structure, layout, use of spell checker, charts and tables in text [5 marks]
o Conclusion [5 marks]
 Analysis
o Description of the data. [10 marks]
o Investigation of factors affecting the amount of exercise undertaken in a week. [10 marks]
[Continued on next page]
This document is for Coventry University students for their own use in completing their assessed work for this module and should not be
passed to third parties or posted on any website. Any infringements of this rule should be reported to acreg.fbl@coventry.ac.uk

Use the survey data to conduct regression analysis to investigate the relationship between the time taken from the student’s accommodation to Coventry University and the time spent doing moderate or vigorous exercise per week.
1. Conduct linear regression analysis.
 Perform, using Excel, Data Analysis Pack, Regression function, the regression analysis
[5 marks]
2. Produce the scatterplot including a fitted regression line.
[5 marks]
3. Write the regression equation using the results of the excel table.
[4 marks]
4. Determine and interpret the slope [3 marks]
5. Determine and interpret the intercept.
[3 marks]
6. Determine and interpret the R-squared value. [5 marks]
7. Give predictions for the time spent on the internet when the time taken from student accommodation to Coventry University is:
a. 25 minutes [3 marks]
b. 35 minutes [3 marks]
8. Are the variables in your regression model statistically significant to your model? Give a justification for your answer. [4 marks]

Sample Solution

ACED ESSAYS