Only Task 2 of the attached document.

This assignment is an individualassignment.

This assignment requires you to perform the following tasks:

Task 1: (25 Marks)

1. Create a small project within an organisation of any industry you choose and include at least 8 activities with predecessors (show each activity name, duration and code in a table) (8 marks)

2. Draw the project network showing each activity earliest and attest starting and finishing time, duration, total float, and the critical path. (17 Marks)

Task 2: [35 Marks]

The attached file named “CW2 Survey Data.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 type of type of accommodation students stay in during term time.

The report should contain quantitative information, summary statistics and appropriate charts and tables.

The marking scheme is as follows:

• Report Structure and Presentation

1. Introduction and summary [5 marks]

2. Structure, layout, use of spell checker, charts and tables in text [5 marks]

3. Conclusion [5 marks]

• Analysis

a. Description of the data. [10 marks]

b. Investigation of factors affecting choice of term time accommodation. [10 marks]

Task 3 [40 Marks]

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 on the Internet per day.

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. [5 marks]

4. Determine and interpret the slope and the intercept. [8 marks]

5. Determine and interpret the R-squared value. [5 marks]

6. Give predictions for the time spent on the internet when the time taken from student accommodation to Coventry University is:

a. 90 minutes [4 marks]

b. 70 minutes [4 marks]

7. Are the variables in your regression model statistically significant to your model?

Give a justification for your answer. [4 marks]