4410809-18292900MATH 1031 STATISTICS FOR BUSINESS
4410809-18292900MATH 1031 STATISTICS FOR BUSINESS
APPLIED PROJECT PART B
MARKING GUIDE-2023.3
Group Members:
Question 1 What is expected of the student Marks Comments
The group is to:
a) Correctly transfer the data into Table 2 /1 b) Obtain the correct Descriptive Statistics summary output /1 c) Obtain the histogram correct graph /0.5 correct data /0.5 correct number of bins /0.5 reduced the gap between the columns to zero /0.5 correct axes labels /0.5 graph title /0.5 d) Correctly comment the approximate shape of the distribution about the skewness /1 e) Give the correct justification compare the appropriate numerical measures ( mean, mode and median) /0.5 justification by referring to the above order /0.5 f) Present a clear discussion by referring to shape /0.5 referring to numerical measures /0.5 g) Give the correct confidence interval correct margin of error /1 correct upper boundary /0.5 correct lower boundary /0.5
TOTAL /10
Question 2
What is expected of the student Marks Comments
The group is to:
a) Correctly transfer the data into Table 3 /1 b) Obtain the correct values and record sample sizes /1 sample means /1 sample standard deviations /1 c) Calculate the correct value of standard error correct formula /0.5 correct substitution /0.5 correct evaluation/value /1 d) State the correct degree of freedom /1 e) State the correct critical value /1 f) Calculate the correct confidence interval margin of error /0.5 upper level /0.25 Lower level /0.25 g) Present a correct interpretation in the context of the problem /1
TOTAL /10
Question 3
What is expected of the student Marks Comments
The group is to:
a) Correctly transfer the data into Table 4 /1 b) Correctly state the hypothesis statements /1 c) Obtain the correct output correct analysis tool for the correct hypothesis test /1 correct variables /1 correct mean difference /0.5 correct alpha /0.5 d) Correctly obtain the values from the output and indicate clearly correct p-value /0.5 correct critical value /0.5 correct test statistic /0.5 correct rejection zone /0.5 e) State the correct decision with correct justification correct decision /1 correct justification /1 f) Correct conclusion in the context of the problem /1 TOTAL /10
Question 4
What is expected of the student Marks Comments
The group is to:
a) Correctly transfer the data into Table 5 /1 b) State the independent and dependent variables in the context of the given data. /1 c) Obtain a correct regression output correct output /1 correct use of x and y variables /1 d) Obtain the correct scatter plot for the given variables correct plot /0.5 regression line /0.5 axes labels /0.5 graph title /0.5 e) Obtain the correct value of correlation coefficient correct numerical value /0.5 correct sign (+ or -) /0.5 f) Present an interpretation of correlation coefficient by referring to sign /1 referring to numerical /1 g) Provide a correct answer with explanation correct answer /0.5 correct explanation /0.5
TOTAL /10
2019300000
The College
APPLIED PROJECT PART B TERM 3 2023
STUDENT NAME STUDENT ID SIGNATURE
UNIT NAME: Statistics for Business
UNIT NUMBER: MATH 1031
NUMBER OF QUESTIONS: 4
VALUE OF QUESTIONS: Each question is worth 10 marks.
Total marks: 40
WEIGHTING: 20%
ANSWERING QUESTIONS: This is a Microsoft Excel based project. All handwritten answers are to be written on the space provided in this document.
LECTURER/UNIT COORDINATOR: Kenneth Gan/ Hima Withana
DUE DATE: 28th January 2024, 11.59 pm TOTAL PAGES: 7
INSTRUCTIONS TO STUDENTS
Attempt ALL tasks. The tasks are to be completed using the Excel file SFB Applied Project Part B 2023.3.xlsx
ALL calculations must be done using MICROSOFT EXCEL
All Excel work must be done in the file: SFB Applied Project Part B 2023.3.xlsx.
All answers in the word document must match the calculations done in Excel.
This is a group task and participation of all members of the group is compulsory.
Each group must submit only one submission.
Assignments submitted after the due date and time will attract a late penalty in accordance with the WSU the College Assessment policy.
Important Notice:
This project is a group assessment task and participation of all members of the group is compulsory. Only one submission from each group will be marked.
The project needs submission of work in two parts:
The following files must be uploaded on vUWS before 11.59 pm on Sunday 28 January 2024 (Week 11)
The excel file SFB Applied Project Part B 2023.3.xlsx.
The word file including answers to questions in this booklet.
How to upload to vUWS:
Click on: Assessment 3B: Applied Project Part A (20%) / Applied Project Part B (2023.3)Select upload files . Upload both Excel and Word document. (If you are not sure, ask your teacher).
Introduction:
In part B of the Applied Project, you will continue your investigation in Part A with your group members.
The Microsoft Excel file named SFB Applied Project Part B 2023.3.xlsx is to be used for this project. It can be downloaded from vUWS.
You must also refer to the marking guide when answering the questions.
Data set:
You will use the data collected in Part A from all your group members as your data set.
Copy the data from all your group members into Table 1 in the worksheet named Data Set Part B in the Excel file SFB Applied Project Part B 2023.3.xlsx prior to commencing your work.
You must use this as your sample data to answer all the questions.
Question 1(10 marks)Marks
In this question you are to investigate the difference in information retention between handwriting and typing by performing a numerical and graphical analysis using the calculated Difference (%)'.
Refer to the worksheet named Question 1 in the Excel file SFB Applied Project Part B 2023.3.xlsx
All Excel work for this question must be done in this worksheet.
Copy the data in Table 1 Difference (%) column into Table 2*.[1]
Using Excel obtain the Descriptive Statistics summary output for the Difference (%).*[1]
Using Excel, construct a histogram showing the distribution of Difference (%) with 8 classes*.[3]
Briefly comment on the shape of the distribution of the histogram you obtained above by referring to its skewness.[1]
Do the numerical results you obtained in part b) agree with the shape you described in part d)? Justify your answer. (No justification, no marks)[1]
Discuss the difference in retention between handwriting and typing by referring to the shape of your histogram and numerical measures.[1]
Using an appropriate Excel output, construct a 90% confidence interval for the population mean difference in retention percentage*.[2]
* Evidence of work in Excel is required
Question 2(10 marks)Marks
In this question you are to explore the difference in the information retention between handwriting and typing by estimating the difference in population means using your sample data. To do this you will construct a 95% confidence interval for the difference between the mean retention percentage by handwriting and the mean retention percentage by typing.
Assume that the variances of the two populations are equal and the two samples are independent.
Refer to the worksheet named Question 2 in the Excel file SFB Applied Project Part B 2023.3.xlsx
All Excel work for this question must be done in this worksheet.
Copy the data from the corresponding columns in Table 1 into Table 3*.[1]
Using Excel obtain the measures in the table below for the two groups: handwriting and typing and complete the table.
You must use appropriate Excel functions to obtain the values*.[3]
Handwriting Typing
Sample size Sample mean Sample standard deviation Calculate the standard error using the appropriate formula from the formula booklet. (You may use the calculator or Excel).[2]
What is the degrees of freedom?[1]
What is the critical value?[1]
Hence construct the confidence interval.[1]
Interpret your confidence interval.[1]
* Evidence of work in Excel is required
Question 3(10 marks)Marks
In this question, you are to investigate if the retention percentage is higher when handwriting than when typing by conducting a hypothesis test. To do this you will carry out a paired t-test at a 5% significant level to determine if the retention percentage when handwriting is significantly greater than when typing.
Refer to the worksheet named Question 3 in the Excel file SFB Applied Project Part B 2023.3.xlsx
All Excel work for this question must be done in this worksheet.
Copy the data from the corresponding columns in Table 1 into Table 4*.[1]
State the null and alternative hypotheses.[1]
Using Excel obtain the correct output*.[3]
Clearly indicate the p-value, critical value, observed value (test statistic) and the rejection zone in the diagram below.[2]
What is the decision about your hypothesis statement, at a significance level of 5%? Clearly justify your answer using appropriate numerical values.[2]
What do you conclude about the difference in retention between handwriting and typing? [1][1]
* Evidence of work in Excel is required
Question 4(10 marks)Marks
In this question you are to examine if the there is a correlation between the total number of characters and the difference in the retention rate.
Refer to the worksheet named Question 4 in the Excel file SFB Applied Project Part B 2023.3.xlsx
All Excel work for this question must be done in this worksheet
Copy the data from the corresponding columns in Table 1 into Table 5*.[1]
State the independent and dependent variables in the context of the question.[1]
Using Excel, obtain a linear regression output. *[2]
Using Excel, construct the scatter plot and insert the regression line. You must clearly label the axes and name it with a suitable title.*[2]
Using the outputs you obtained or otherwise, state the correlation coefficient correct to 2 significant figures*.[1]
coefficient of correlation r =
Discuss how the difference in retention rate is affected by the total number of characters. You must support your discussion with appropriate measures from above outputs.[2]
Is this model suitable to predict the difference in retention rate? Explain why.[1]
* Evidence of work in Excel is required
END OF PROJECT
