Description
Graded Assignment for Chapter 9 (Hypothesis Testing). It is on a spreadsheet, and question 3 used another spreadsheet which is the second tab on the assignment. Put answers in the red boxes; show the formulas or Excel functions you use in making calculations.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi there!Attached is the completed Excel assignment. Please look it over, and let me know if you have any questions :)Thanks again,Selenica
ECON 260 GRADED ASSIGNMENT CHAPTER 9
POINTS: _______ PERCENTAGE: ________
(50 POINTS TOTAL)
PUT ANSWERS WITHIN THE BOXES IN EACH QUESTION. SUBMIT THE SPREADSHEET THROUGH CANVAS. IN THE
CELLS DO NOT SIMPLY WRITE THE ANSWER BUT PUT IN THE EXCEL FUNCTIONS OR CALCULATIONS SO I CAN SEE
𝑥ҧ
WHAT YOU DID TO GET THE ANSWERS.USE THE FORMULAS ON THE FORMULA SHEET.
NUMERICAL ANSWERS TO 3 DECIMAL PLACES.
I SUGGEST YOU SKETCH GRAPHS OF THE DISTRIBUTIONS AND WRITE OUT THE FORMULAS IF THAT HELPS TO
CLARIFY THE SOLUTION TO YOU.
1
Consider the following hypothesis test: (16 points total on #1)
H 0 : μ ≤ 50
H a : μ > 50
A sample of 61 is used; the sample standard deviation is s = 8 (the population standard
deviation is NOT known).
2
a.
Is this a right-tailed (upper tailed) or left-tailed (lower-tailed) test or a two-tailed test?
Right-tailed
b.
Step 1:
Step 2:
Step 3:
Step 4:
Develop the null and alternative hypotheses (done above)
Specify the level of significance (use α = 0.01)
Collect the sample data, calculate the sample mean, sample
standard deviation, standard error of the mean, and the test
statistic:
𝑥ҧ = 52.5
s=8
=
Should you use the standard normal distribution or the t- distribution:
If it is a t -distribution, how many degrees of freedom df?
The test statistic (z or t ) =
Compute the p -value (refer to the matrix for the formula):
Step 5:
Do you reject H 0 ?
Step 6:
What is your conclusion from this test?
1,024
t-distribution
60
2,441
2,390
Yes
μ > 50
Consider the following hypothesis test: (16 points total on #1)
H 0 : μ = 22
H a : μ ≠ 22
A sample of 81 is used; the sample standard deviation is s = 10 (the populatio...