EA 9 ANSWER FORM

pdf

School

Purdue University *

*We aren’t endorsed by this school

Course

30301

Subject

Statistics

Date

Apr 3, 2024

Type

pdf

Pages

3

Uploaded by Flightologist

Report
STAT 30301 EXCEL ACTIVITY 9: ANSWER FORM 20 points Enter your answers & Excel outputs by their problem numbers. Save completed form as a pdf. Submit completed pdf of THIS FORM to your Brightspace STAT 30301 Merge Course for credit. GO TO NEXT PAGE FOR #7 - #17 1. Type your answer below. (1 point) D bar is the average difference between before and after weights. 2. Type your answer below. (1 point) Ho: D bar >= 0 Ha: D bar <0 3. Type your answer below. (2 points) =(H8-H16)/H9 = 0.299 4. Type your answer below. (1 point) P value = .0138 5. Paste your output below: (1 point) Weight Before Weight After Mean 163.5075 163.1003 Variance 384.8329 386.11 Observations 71 71 Pearson Correlation 0.997609 Hypothesized Mean Difference 0 df 70 t Stat 2.526212 P(T<=t) one-tail 0.006897 t Critical one-tail 2.380807 P(T<=t) two-tail 0.013795 t Critical two-tail 2.647905 6. Type your answer below: (1 point) P Value = .013795
7. Type your answer below. (1 point) (-1.49,2.49) 8. Type your answer below. (2 points) We must accept the Null hypothesis, as p hat is in the acceptable range. 9. Type your answer below: (1 point) 10. Type your answer below. (1 point) 11. Type your answer below. (1 point) 12. Type your answer below. (1 point) 13. Type your answer below: (2 points) 14. Type your answer below. (1 point) 15. Type your answer below. (1 point) 16. Type your answer below. (2 points) 17. SAVE THIS ANSWER FORM Document AS A PDF ; any other file type will receive AT MOST 75% credit for the assignment. Upload your SINGLE pdf file to the Excel Activity 9 Assignment in the Brightspace Merge course .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help