Display the excel regression summary table and write the estimated linear equation
1305AFE Business Data Analysis
Questions 1 to 4 are related
In addition, students were also asked to respond to survey questions concerning other variables (e.g. major of study chosen, suburb where student lives, country of origin, etc). The lecturer categorised the data collected on the variable suburb where student lives into ten suburbs, and calculated the frequencies as presented in the table below.
| Suburb | |
|---|---|
| Category | Frequency |
| Suburb A | 3 |
| Suburb B | 9 |
| Suburb C | 7 |
| Suburb D | 6 |
| Suburb E | 8 |
| Suburb F | 7 |
| Suburb G | 5 |
| Suburb H | 5 |
| Suburb I | 2 |
| Suburb J | 3 |
Using the information presented in the table above, answer the following questions.
The lecturer wishes to draw histograms in presenting graphical summaries of the data on the two main variables concerned - weekly working hours and marks attained, as stored in ‘HoursMark55’ worksheet.
She decided to use 7 class intervals to construct a histogram for each variable. Explain how the lecturer could have decided in using 7 as the number of class intervals to be used. 1 mark
The lecturer would like to present numerical descriptive measures to summarize the data on the two variables: weekly working hours and marks attained.
Using the relevant Excel function, prepare and display a numerical summary report for each of the two variables including measures such as mean, median, mode, range, variance, standard deviation, smallest and largest values, and the three quartiles. Also, calculate and display the coefficient of variation value for each of the two variables.
Specify the dependent variable and the independent variable for this regression analysis. Briefly explain the reasoning for your selection. 1 mark
Use an appropriate graphical technique to draw a diagram that evaluates the relationship between the two variables. Display the diagram. On the same diagram, fit a linear trend line including the equation and the coefficient of determination R2.
A recording label/entertainment promoter wishes to do a linear regression analysis to predict the concert attendance of an established Korean-pop band in their upcoming tour in 2021. He believes that the expected number of concert attendees is related and can be explained by the number of times that the band’s songs have been downloaded in the social media. Yearly data concerning the two variables are collected and stored in ‘ConcertDownloads15’ worksheet in the xls. data file attached.
Based on the information provided above, specify the dependent variable and the independent variable for doing the regression analysis. Briefly explain the reasoning for your selection. 1 mark
Display the value of the coefficient of determination. Then, provide an interpretation of the coefficient of determination value in terms of the relationship between the two variables. 1.5 marks
QUESTION 6 _______ 4 marks
