This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
QNT 230 Take home Exam 2 Spring 2019 - Mondays Class
(Use MIcrosoft Excel to solve the 4 problems given here. Problems carry 25 points each and one can score over 100
points with the bonus problems; so please attempt all the problems.
The data sets for the 4 problems are in an Excel file titled “Take home Exam 2 – DATASET” in the BB in four
worksheets. Also see the Hints file titled “Take home Exam 2 – HINTS” in the BB.
The solutions to the problems should be in the Dataset Excel file, with each solution in the same worksheet as the
data. Submit your file to me by email - vaidyanat@hartford.edu – before the due date of 04/14; penalty is 20% for
each day of late submission. Good luck!)
(Show the following steps in arriving at your solution - Step 1: State the null hypothesis and the
alternate hypothesis Step 2: Select the level of significance Steps 3, 4: Select the test statistic and
formulate the decision rule Step 5: DO the calculations, interpret the Excel output and make a
decision. Clearly indicate acceptance/reject regions – preferably a Graph or precise wording)
Problem 1 (Chap 10 One Sample test of Hypothesis) The 2 data sets provided are the SAT scores for 2
samples of students who applied for University admission at 2 universities - University-1 and University-
2. Review the data carefully and complete the following.
1. Do a hypothesis test on the SAT scores of students who applied for admission at University-1 to
see if it is reasonable to conclude the population mean is over 1400? Test using .05 level of
significance
Trusted by Thousands of
Students
Here are what students say about us.
Resources
Company
Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.