ANova

subject Type Homework Help
subject Pages 2
subject Words 574
subject School University of Hartford
subject Course QNT 340

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
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
page-pf2

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.