Assignment: Correlation and Regression
Analysis
Question 1: Correlation and Regression for Sales Data
Month Advertising (X) Sales (Y)
1 5 40
2 10 55
3 8 50
4 12 65
5 7 48
6 15 70
Tasks:
• Calculate the Pearson correlation coefficient (r) between advertising and sales.
• Find the linear regression equation of Y on X.
• Estimate the sales revenue if the company spends 9 thousand riyals on advertising.
• Interpret the meaning of the correlation value.
Question 2: Correlation and Regression for Study Hours and Exam Scores
Student Hours Studied (X) Exam Score (Y)
A 2 60
B 4 65
C 5 70
D 3 62
E 6 75
F 8 80
G 7 78
H 1 55
Tasks:
• Calculate the Pearson correlation coefficient (r).
• Find the least-squares regression line (equation of Y on X).
• Predict the exam score for a student who studies for 5.5 hours.
• Explain whether the relationship between hours studied and exam score is strong.
Question 3: Correlation and Regression for Temperature and Ice Cream Sales
Day Temperature (X) Ice Creams Sold (Y)
1 30 150
2 32 160
3 35 180
4 31 155
5 33 165
6 29 145
7 36 185
Tasks:
• Draw a scatter plot of the data.
• Calculate the correlation coefficient (r).
• Find the equation of the regression line (Y on X).
• Predict how many ice creams would be sold if the temperature reaches 34°C.
Question 4: Correlation and Regression Using Grouped Data
Department Average Training Hours (X) Productivity Score (Y)
HR 10 72
Sales 12 78
IT 8 70
Finance 15 85
Marketing 9 73
Tasks:
• Calculate the mean of X and Y.
• Find the correlation coefficient (r).
• Find the regression equation (Y on X).
• Predict the productivity score for a department with 11 hours of training.
• Comment briefly on the relationship between training and productivity.
