Homework Help is Here – Start Your Trial Now!
Science
Physics
Exercise #2 Use the Using Excel for Normal Probabilities instructions for the following. In a recent year, the ACT scores for high school students with an A or B grade point average were normally distributed with a mean of 24.2 and a standard deviation of 4.2. A student with an A or B average who took the ACT during this time is selected. 1. Find the probability that the student's ACT score is less than 20. 2. Find the probability that the student's ACT score is greater than 31. 3. Find the probability that the student's ACT score is between 25 and 32. 4. Find the probability that in a sample of size 100, the mean ACT score is between 25 and 32. 5. Find the cutoffs for the middle 90% for the mean ACT scores in a sample of size 100.

Exercise #2 Use the Using Excel for Normal Probabilities instructions for the following. In a recent year, the ACT scores for high school students with an A or B grade point average were normally distributed with a mean of 24.2 and a standard deviation of 4.2. A student with an A or B average who took the ACT during this time is selected. 1. Find the probability that the student's ACT score is less than 20. 2. Find the probability that the student's ACT score is greater than 31. 3. Find the probability that the student's ACT score is between 25 and 32. 4. Find the probability that in a sample of size 100, the mean ACT score is between 25 and 32. 5. Find the cutoffs for the middle 90% for the mean ACT scores in a sample of size 100.

College Physics
College Physics
11th Edition
ISBN:9781305952300
Author:Raymond A. Serway, Chris Vuille
Publisher:Raymond A. Serway, Chris Vuille
Chapter1: Units, Trigonometry. And Vectors
Section: Chapter Questions
Problem 1CQ: Estimate the order of magnitude of the length, in meters, of each of the following; (a) a mouse, (b)...
See similar textbooks
icon
Related questions
Question

EXERCISE 1 ONLY

In steps 4 and 5 for Exercise #1, please note the following corrections in the instructions:

4.  Enter the formula = AVERAGE(A1:AD1) in cell AE1 to compute the average of the first sample of
size 30.
5.   Activate cell AE1, click the fill handle + in the lower right hand corner and drag to cell AE1000 to
fill the column sample means from the 1000 samples.

**Exercise #2** Use the Using Excel for Normal Probabilities instructions for the following. In a recent year, the ACT scores for high school students with an A or B grade point average were normally distributed with a mean of 24.2 and a standard deviation of 4.2. A student with an A or B average who took the ACT during this time is selected. 1. Find the probability that the student's ACT score is less than 20. 2. Find the probability that the student's ACT score is greater than 31. 3. Find the probability that the student's ACT score is between 25 and 32. 4. Find the probability that in a sample of size 100, the mean ACT score is between 25 and 32. 5. Find the cutoffs for the middle 90% for the mean ACT scores in a sample of size 100.
Transcribed Image Text:**Exercise #2** Use the Using Excel for Normal Probabilities instructions for the following. In a recent year, the ACT scores for high school students with an A or B grade point average were normally distributed with a mean of 24.2 and a standard deviation of 4.2. A student with an A or B average who took the ACT during this time is selected. 1. Find the probability that the student's ACT score is less than 20. 2. Find the probability that the student's ACT score is greater than 31. 3. Find the probability that the student's ACT score is between 25 and 32. 4. Find the probability that in a sample of size 100, the mean ACT score is between 25 and 32. 5. Find the cutoffs for the middle 90% for the mean ACT scores in a sample of size 100.
**Excel Project #3** This is a multi-part assignment using various functions in Microsoft Excel. You should start the project as soon as it becomes available. You can find all the procedures for performing the tasks required for this assignment in the Excel Notes folder in Canvas. Do not hesitate to contact me if you have any questions. For each exercise, you must: - Copy and paste the output (not the original input data) to the included template - Organize the output in the order of the questions (e.g., Ex #1, Ex #2, etc.) - Submit the final Word file with the output to Canvas in the appropriate Excel Project folder **Exercise #1** Construct Sampling Distributions using Various Probability Distributions **Construct a sampling distribution of the sample means from a Uniform distribution from (0, 1)** by taking 1000 samples of size n = 30. For each sample, find the mean \( \bar{x} \) and then make a histogram of these 1000 values. **Procedure - Uniform** 1. Activate cell A1. 2. Choose the Data tab, then select Data Analysis > Random Number Generation. 3. Complete the dialog box: - Number of Variables: 30 - Number of Random Numbers: 1000 - Distribution: Uniform - Parameters: Between 0 and 1 - Then click OK. 4. Enter the formula =AVERAGE(A1:AD2) in cell AE2 to compute the average of the first sample of size 30. 5. Activate cell AE2, click the fill handle + in the lower right-hand corner and drag to cell AE1000 to fill the column with sample means from the 1000 samples.
Transcribed Image Text:**Excel Project #3** This is a multi-part assignment using various functions in Microsoft Excel. You should start the project as soon as it becomes available. You can find all the procedures for performing the tasks required for this assignment in the Excel Notes folder in Canvas. Do not hesitate to contact me if you have any questions. For each exercise, you must: - Copy and paste the output (not the original input data) to the included template - Organize the output in the order of the questions (e.g., Ex #1, Ex #2, etc.) - Submit the final Word file with the output to Canvas in the appropriate Excel Project folder **Exercise #1** Construct Sampling Distributions using Various Probability Distributions **Construct a sampling distribution of the sample means from a Uniform distribution from (0, 1)** by taking 1000 samples of size n = 30. For each sample, find the mean \( \bar{x} \) and then make a histogram of these 1000 values. **Procedure - Uniform** 1. Activate cell A1. 2. Choose the Data tab, then select Data Analysis > Random Number Generation. 3. Complete the dialog box: - Number of Variables: 30 - Number of Random Numbers: 1000 - Distribution: Uniform - Parameters: Between 0 and 1 - Then click OK. 4. Enter the formula =AVERAGE(A1:AD2) in cell AE2 to compute the average of the first sample of size 30. 5. Activate cell AE2, click the fill handle + in the lower right-hand corner and drag to cell AE1000 to fill the column with sample means from the 1000 samples.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Frequency and wavelength of EM waves
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, physics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Physics
College Physics
Physics
ISBN:
9781305952300
Author:
Raymond A. Serway, Chris Vuille
Publisher:
Cengage Learning
University Physics (14th Edition)
University Physics (14th Edition)
Physics
ISBN:
9780133969290
Author:
Hugh D. Young, Roger A. Freedman
Publisher:
PEARSON
Introduction To Quantum Mechanics
Introduction To Quantum Mechanics
Physics
ISBN:
9781107189638
Author:
Griffiths, David J., Schroeter, Darrell F.
Publisher:
Cambridge University Press
Physics for Scientists and Engineers
Physics for Scientists and Engineers
Physics
ISBN:
9781337553278
Author:
Raymond A. Serway, John W. Jewett
Publisher:
Cengage Learning
Lecture- Tutorials for Introductory Astronomy
Lecture- Tutorials for Introductory Astronomy
Physics
ISBN:
9780321820464
Author:
Edward E. Prather, Tim P. Slater, Jeff P. Adams, Gina Brissenden
Publisher:
Addison-Wesley
College Physics: A Strategic Approach (4th Editio…
College Physics: A Strategic Approach (4th Editio…
Physics
ISBN:
9780134609034
Author:
Randall D. Knight (Professor Emeritus), Brian Jones, Stuart Field
Publisher:
PEARSON
SEE MORE TEXTBOOKS