EA 2 ANSWER FORM - Khanh Ngo
pdf
keyboard_arrow_up
School
Purdue University *
*We aren’t endorsed by this school
Course
30301
Subject
Statistics
Date
Feb 20, 2024
Type
Pages
3
Uploaded by CorporalStar105672
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
Related Documents
Related Questions
Need help asap
arrow_forward
An insurance company hires an actuary to determine whether the number of hours of safety drivingclasses can be used to predict the number of driving accidents for each driver. Identify theexplanatory variable, if any.
arrow_forward
A lecturer at WIN wanted to know if he can predict student’s quiz results by asking them to complete a simple survey. The result of the survey is found in the file: Assignment 2 sem22020 data set 1.Quiz ResultActual Mark (0-15) for quiz student attainedEQRQuiz score (0-15) expected to get before taking the quizStudy Hrs.Number of hours per week (on average) spent studying for StatisticsAgeAge (in years)BBTSatisfaction rating of Big Bang TheorySexM=1 F=0MBMB=1 for good math background, otherwise 0MCMC= 1 if math centre is used regularly, otherwise 0AuHSAuHS = 1 if student completed high school in Australia, otherwise 0LMLM=1 if student likes math, 0 otherwiseTask 1: Variable List(a) Using the variables listed in the table above, Describe each variable.(b) State for each variable whether it is qualitative or quantitative; if it is qualitative, state whether it is nominal or ordinal, and if it is quantitative, state whether it is discrete or continuous.Task 2: HistogramCreate a histogram…
arrow_forward
The standard
arrow_forward
Evaluate.
arrow_forward
Suppose you have information about average heights of a random sample of airline passengers. The mode is 64 inches, the median is 73 inches, and the mean is 75 inches. To convert the data into centimeters, multiply each data value by 2.54. What are the values of the mode, median, and mean in centimeters? (Enter your answers to two decimal places.)
arrow_forward
please answer all of the questions in the pictures!
arrow_forward
Suppose that the length of time between consecutive high tides is 12 hours and 26 minutes. According to the National
Oceanic and Atmospheric Administration, on a particular day in a city, high tide occurred at 12:26 AM (0.43 hours) and
low tide occurred at 7:08 AM (7.13 hours). Water heights are measured as the amounts above or below the mean lower low
water. The height of the water at high tide was 5.92 feet and the height of the water at low tide was 0.04 foot. Complete parts
(a) through (c).
(a) Approximately when will the next high tide occur?
The next high tide will occur at 12:52 PM.
(b) Find a sinusoidal function of the form y = A sin (ox - $) + B that models the data.
y =
=sin(x++□
(Simplify your answers. Round to the nearest thousandth as needed.)
66
arrow_forward
What type of relationship is indicated in the scatterplot7
arrow_forward
Suppose that the length of time between consecutive high tides is 12 hours and 28 minutes. According to the National Oceanic
and Atmospheric Administration, on a particular day in a city, high tide occurred at 12:28 AM (0.47 hours) and low tide occurred at
7:05 AM (7.08 hours). Water heights are measured as the amounts above or below the mean lower low water. The height of the
water at high tide was 5.92 feet and the height of the water at low tide was 0.06 foot. Complete parts (a) through (c).
(a) Approximately when will the next high tide occur?
The next high tide will occur at 12:56 PM.
(b) Find a sinusoidal function of the form y = A sin (ax -) +B that models the data.
y = 2.93 sin (0.504 x + 1.335 ) + 2.99
(Simplify your answers. Round to the nearest thousandth as needed.)
(c) Use the function found in part (b) to predict the height of the water at 4 PM.
The height of the water at 4 PM is approximately ft.
(Simplify your answer. Type an integer or decimal rounded to the nearest…
arrow_forward
List an advatge of microdata, and of aggregated data
Answer in a few sentences thank you.
arrow_forward
Round 0.29 to the nearest tenth.
arrow_forward
Here is a set of 20 values in order:
1, 2, 5, 10, 11, 12, 14, 15, 15, 16, 18, 19, 20, 21, 22, 24, 25, 28, 32, 45
Do not use software for this question. Using your pencil, paper, and perhaps your calculator, determine the values for the 5 Number Summary for this set of data and type your answer into the essay text box.
arrow_forward
Can anyone please send me the normal standard table
arrow_forward
Please help 31-32 help
arrow_forward
Discuss
characteristics
of academic
writing.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9780998625713/9780998625713_smallCoverImage.jpg)
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Related Questions
- Need help asaparrow_forwardAn insurance company hires an actuary to determine whether the number of hours of safety drivingclasses can be used to predict the number of driving accidents for each driver. Identify theexplanatory variable, if any.arrow_forwardA lecturer at WIN wanted to know if he can predict student’s quiz results by asking them to complete a simple survey. The result of the survey is found in the file: Assignment 2 sem22020 data set 1.Quiz ResultActual Mark (0-15) for quiz student attainedEQRQuiz score (0-15) expected to get before taking the quizStudy Hrs.Number of hours per week (on average) spent studying for StatisticsAgeAge (in years)BBTSatisfaction rating of Big Bang TheorySexM=1 F=0MBMB=1 for good math background, otherwise 0MCMC= 1 if math centre is used regularly, otherwise 0AuHSAuHS = 1 if student completed high school in Australia, otherwise 0LMLM=1 if student likes math, 0 otherwiseTask 1: Variable List(a) Using the variables listed in the table above, Describe each variable.(b) State for each variable whether it is qualitative or quantitative; if it is qualitative, state whether it is nominal or ordinal, and if it is quantitative, state whether it is discrete or continuous.Task 2: HistogramCreate a histogram…arrow_forward
- The standardarrow_forwardEvaluate.arrow_forwardSuppose you have information about average heights of a random sample of airline passengers. The mode is 64 inches, the median is 73 inches, and the mean is 75 inches. To convert the data into centimeters, multiply each data value by 2.54. What are the values of the mode, median, and mean in centimeters? (Enter your answers to two decimal places.)arrow_forward
- please answer all of the questions in the pictures!arrow_forwardSuppose that the length of time between consecutive high tides is 12 hours and 26 minutes. According to the National Oceanic and Atmospheric Administration, on a particular day in a city, high tide occurred at 12:26 AM (0.43 hours) and low tide occurred at 7:08 AM (7.13 hours). Water heights are measured as the amounts above or below the mean lower low water. The height of the water at high tide was 5.92 feet and the height of the water at low tide was 0.04 foot. Complete parts (a) through (c). (a) Approximately when will the next high tide occur? The next high tide will occur at 12:52 PM. (b) Find a sinusoidal function of the form y = A sin (ox - $) + B that models the data. y = =sin(x++□ (Simplify your answers. Round to the nearest thousandth as needed.) 66arrow_forwardWhat type of relationship is indicated in the scatterplot7arrow_forward
- Suppose that the length of time between consecutive high tides is 12 hours and 28 minutes. According to the National Oceanic and Atmospheric Administration, on a particular day in a city, high tide occurred at 12:28 AM (0.47 hours) and low tide occurred at 7:05 AM (7.08 hours). Water heights are measured as the amounts above or below the mean lower low water. The height of the water at high tide was 5.92 feet and the height of the water at low tide was 0.06 foot. Complete parts (a) through (c). (a) Approximately when will the next high tide occur? The next high tide will occur at 12:56 PM. (b) Find a sinusoidal function of the form y = A sin (ax -) +B that models the data. y = 2.93 sin (0.504 x + 1.335 ) + 2.99 (Simplify your answers. Round to the nearest thousandth as needed.) (c) Use the function found in part (b) to predict the height of the water at 4 PM. The height of the water at 4 PM is approximately ft. (Simplify your answer. Type an integer or decimal rounded to the nearest…arrow_forwardList an advatge of microdata, and of aggregated data Answer in a few sentences thank you.arrow_forwardRound 0.29 to the nearest tenth.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
![Text book image](https://www.bartleby.com/isbn_cover_images/9780998625713/9780998625713_smallCoverImage.jpg)
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University