EA 2 ANSWER FORM - Khanh Ngo

pdf

School

Purdue University *

*We aren’t endorsed by this school

Course

30301

Subject

Statistics

Date

Feb 20, 2024

Type

pdf

Pages

3

Uploaded by CorporalStar105672

Report
STAT 30301 – EXCEL ACTIVITY 2: 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 Course for credit. GO TO NEXT PAGE FOR #5 - #10 1. Paste your Excel output below. (2 points) Column1 Mean 15200.39838 Standard Error 271.1149728 Median 15193.1 Mode #N/A Standard Deviation 2856.373481 Sample Variance 8158869.463 Kurtosis 0.11536163 Skewness 0.167295567 Range 16149.09 Minimum 8158.26 Maximum 24307.35 Sum 1687244.22 Count 111 2. Type your answer below. (2 points) Mean: 15200.40 Standard Deviation: 2856.37 3. Paste your Excel output below. (3.5 points) Minimum 8158.26 Quartile 1 13266.975 Quartile 2 15193.1 Quartile 3 17121.175 Maximum 24307.35 4. Type your answers in the table below. (1.5 points) IQR 3854.20 Lower Limit 7485.68
STAT 30301 – EXCEL ACTIVITY 2: 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 Course for credit. GO TO NEXT PAGE FOR #5 - #10 Upper Limit 22902.48
5. Type your answer below. (2 points) Can the Minimum be considered an outlier? Explain using the limits from #4. No, because the Lower Limit is smaller than the minimum. Can the Maximum be considered an outlier? Explain using the limits from #4. Yes, because the Upper Limit is smaller than the Maximum which means that it is an outlier. 6. Type your answers in the table below. (3 points) Label Value (x) z-score If the data distribution were bell-shaped, would this be consider an outlier? Minimum 8158.26 -2.47 No Maximum 24307.35 3.19 Yes 7. Type your answer below. (2 points) Since the z score for the Maximum is greater than 3.00, it means that it would be considered an outlier. 8. Paste your Excel output below. (3 points) 9. Type your answer below. (1 point) There is one high outlier, 24307.35 10. 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 2 assignment in Brightspace .
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