Question

Find the mean and standard deviation of the DRIVE variable by using =AVERAGE(A2:A36) and =STDEV(A2:A36). Assuming...

  1. Find the mean and standard deviation of the DRIVE variable by using =AVERAGE(A2:A36) and =STDEV(A2:A36). Assuming that this variable is normally distributed, what percentage of data would you predict would be less than 40 miles? This would be based on the calculated probability. Use the formula =NORM.DIST(40, mean, stdev,TRUE). Now determine the percentage of data points in the dataset that fall within this range. To find the actual percentage in the dataset, sort the DRIVE variable and count how many of the data points are less than 40 out of the total 35 data points. That is the actual percentage. How does this compare with your prediction?   (15 points) below is are the drive times provided.  
    4
    6
    6
    20
    20
    25
    25
    28
    29
    33
    33
    36
    36
    36
    36
    40
    42
    54
    54
    55
    63
    63
    71
    73
    73
    76
    76
    76
    76
    78
    80
    80
    80
    88
    94
0 0
Add a comment Improve this question Transcribed image text
Answer #1

mean = 50.4286
std. dev. = 25.9777

probability = 0.3440
expected number = 0.3440*35 = 12.04

actual number = 15

the expected number is less than the actual number.

Add a comment
Know the answer?
Add Answer to:
Find the mean and standard deviation of the DRIVE variable by using =AVERAGE(A2:A36) and =STDEV(A2:A36). Assuming...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Hello experts, any help with the given problems would be greatly appreciated. Give and interpret the...

    Hello experts, any help with the given problems would be greatly appreciated. Give and interpret the p-value at a=.05 for the hypothesis test where we wanted to see if the average hours of sleep is less than 8. Be sure to construct the Null and Alternative Hypothesis first. If you use a=.01, does your interpretation in question 4 change? Explain your reasoning. A student success coach has been told that the mean drive distance to class is 56 miles. Use...

  • Hello experts, any help with the given problems would be greatly appreciated. Give and interpret the...

    Hello experts, any help with the given problems would be greatly appreciated. Give and interpret the p-value at a=.05 for the hypothesis test where we wanted to see if the average hours of sleep is less than 8. Be sure to construct the Null and Alternative Hypothesis first. If you use a=.01, does your interpretation in question 4 change? Explain your reasoning. A student success coach has been told that the mean drive distance to class is 56 miles. Use...

  • For each variable of interest, do the following: 1. Find the mean, five-number summary, range, variance,...

    For each variable of interest, do the following: 1. Find the mean, five-number summary, range, variance, and standard deviation. Display these numbers in a format that is easy to understand. 2. For each variable of interest, use its five-number summary to construct a boxplot. Each boxplot must be constructed horizontally, and must be accompanied by a brief descriptive paragraph that assesses whether the data appear to be symmetrical, left-skewed, or right-skewed. Construct a 95% confidence interval for the mean μ...

  • 6.33 Let x be a continuous random variable that is normally distributed with a mean of 25 and a standard deviation o...

    6.33 Let x be a continuous random variable that is normally distributed with a mean of 25 and a standard deviation of 6. Find the probability that x assumes a value a. between 28 and 34 b. between 20 and 35 6.34 Let x be a continuous random variable that has a normal distribution with a mean of 30 and a stan- dard deviation of 2. Find the probability that x assumes a value a. between 29 and 35 b....

  • Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above...

    Calculate the range, mean, mode, median, Standard deviation Calculate the skewness and kurtosis for the above data and interpret the data. The following is data collected from the daily salary employees of ZZ COMPANY.. 68 19 43 11 37 30 19 67 65 34 96 23 93 73 46 39 21 12 89 52 33 21 18 57 80 56 91 62 56 48 84 23 78 96 49 36 90 42 65 15 43 36 65 59 34 71...

  • Assume the random variable x is normally distributed with mean u = 80 and standard deviation...

    Assume the random variable x is normally distributed with mean u = 80 and standard deviation c=5. Find the indicated probability. P(65<x< 73) P(65<x< 73)=0 (Round to four decimal places as needed.) X 5.2.17 Use the normal distribution of SAT critical reading scores for which the mean is 507 and the standard deviation is 122. Assume the vari (a) What percent of the SAT verbal scores are less than 550? (b) If 1000 SAT verbal scores are randomly selected, about...

  • Conduct a formal hypothesis test of the claim that the mean longevity is less than 57...

    Conduct a formal hypothesis test of the claim that the mean longevity is less than 57 days. Test at significance α=0.05. Your written summary of this test must include the following: Your null and alternate hypotheses in the proper format. The type of distribution you used to construct the interval (t or normal). The P-value and its logical relationship to α (≤ or >). Your decision regarding the null hypothesis: reject or fail to reject. A statement regarding the sufficiency/insufficiency...

  • For each variable of interest – Percent Time Asleep and Longevity – create a grouped frequency...

    For each variable of interest – Percent Time Asleep and Longevity – create a grouped frequency histogram. For each histogram, use a class width of 10; use a lower limit of 0 for Percent Time Asleep and 15 for Longevity. Each histogram must include an informative title, along with correct labels for both axes. For each histogram, include a paragraph that answers each of the following questions: Is the histogram symmetric, skewed to the left, or skewed to the right?...

  • Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the stu...

    Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the student spent participating in a GMU club or sport and working for pay outside of GMU was recorded. Values of 0 indicate the students either does not participate in a club or sport or does not work a job for pay. The goal of...

  • Creating Graphs Create a pie chart for the variable Car Color: Select the column with the...

    Creating Graphs Create a pie chart for the variable Car Color: Select the column with the Car variable, including the title of Car Color. Click on Insert, and then Recommended Charts. It should show a clustered column and click OK. Once the chart is shown, right click on the chart (main area) and select Change Chart Type. Select Pie and OK. Click on the pie slices, right click Add Data Labels, and select Add Data Callouts. Add an appropriate title....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT