Use to the attached file dataset to complete the mini-project 1. The total point for this assignment is 100, which represents 30% of the course grade.
Due Date: April 12th, 2024 by 6.00pm.
Note:
• You are to generate a comprehensive report that covers all questions asked in this project.
• All analyses in must be carried out via the use of a software, MS Excel preferably.
• Name every Excel worksheet to reflect the question being answered.
• Treat the 22 individuals in the data as belonging to one population.
• You are required to use either MS EXCEL and/or any other statistical tool for this assignment. You must specify the tool used and provide formulas, codes or snapshot of all your outputs along with your submission.
• You are going to be grouped into 2 for this assignment. One submission(Excel app only) per group. Upload your submission to Populi. Be sure to indicate the contribution level of each member of the group. Failure to work in a group of two would be subject to a penalty.
Required:
Section A: Graphical Representation
1) Using the “Social Media Account” of the class, construct the following:
a. Frequency count of all social media account by each student. [1]
b. Cumulative Frequency based on (i) above. [2]
c. Using the outcome from (Ai), produce a fully labelled three-dimensional bar chart based on column ‘Major’ [4]
2) Describe the distribution of the “Bible reading” of students in the class by constructing:
a. Histogram (use 5 interval). [4]
b. Boxplot [3]
i. On the plot, indicate the “Five number summary” [5]
Section B: Numerical Representation
1. Using the “Score at the end of study level”, calculate:
a. 80th percentile and interpret your answer [4]
b. Explain why 80th percentile for each study level is different from 80% score.[2]
2. Determine the following:
a. The ‘measures of central tendency’ for the “Shoe Size” of the class [3].
b. The ‘measures of dispersion’ of variable “Shoe Size”. [4]
Section C:
1. Using MS Excel, make a fully labelled scatterplot of “Score at the end of study level” versus “Average number of hours per day studying” [4].
i. Determine the correlation coefficient [2]
ii. What type of relationship exists between the two variables? [2]
iii. What is your interpretation of the relationship between the two variables? [2]
2. Considering “Score at the end of study level” as the response variable:
i. Construct a linear regression equation between the 2 variables [3]
ii. Interpret your result. [2]
iii. What is the difference between the interpretation of your correlation outcome and regression outcome? [2]
3. Considering “Score at the end of study level” as the response variable. “Your Weight”, “Average number of hours per day studying”, “Gender”, “Bible reading (minutes per typical day)”, “Age (in months, to the nearest one decimal place)”, “Average number of hours per day studying”, and “Average number of hours per day spent on social media” as the explanatory variables:
i. Construct a multiple linear regression equation between the response and all the explanatory variables (4 marks).
ii. Interpret your answer (7 marks).
Groups:
Group
Student ID
Populi Name
Student ID
Populi Name
1
53425
Azad Chaudhary
53199
Harmanpreet Singh Maan
2
53279
Amrit Preet Kaur Dhillon
53659
Ishita Parbhakar
3
53543
Mehakdeep Singh Grewal
53537
Prince Kumar
4
53692
Gurpreet Singh
53216
Bhupinderdeep Singh Tur
5
53544
Harkirat Singh Pannu
53438
Sidakveer Singh Kharoud
6
53433
Harmandeep Kaur Brar
53649
Hasandeep Kaur
7
53619
Harpreet Kaur
53838
Sukhmandeep Kaur Sukhmandeep Kaur
8
53559
Harinderpal Singh Sandhawalia
53831
Jasmeet Singh
9
53825
Kamaljit Kaur
53485
Bavleen Kaur
10
53628
Manraj Singh Uppal
53620
Chandanpreet Singh Brar
11
53608
Prabhjoth Singh
53525
Harphool Singh Brar
12
53607
Diksha Sood
53442
Avneet Kaur
13
53517
Sukhchain Singh
53482
Armanpreet Singh
14
53665
Yadwinder Kaur
53460
Prabhjot Kaur Ramgharia
