6. Create a histogram of the means: Using Mega Stat or Excel. For Excel: Make sure to select thecolumn containing the sample means and check the box for Chart Output – leave the Bin Range-box blank.Exercise #2Use 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 werenormally distributed with a mean of 24.2 and a standard deviation of 4.2. A student with an A or Baverage 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 #3This is a multi-part assignment using various functions in Microsoft Excel. You should start the project assoon as it becomes available. You can find all of the procedures for performing the tasks required forthis assignment in the Excel Notes folder in Canvas. Do not hesitate to contact me if you have anyquestions.For each exercise, you must:Copy and paste the output (not the original input data) to the included templateOrganize 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 folderExercise #1Construct Sampling Distributions using Various Probability DistributionsConstruct a sampling distribution of the sample means from aUniform distribution from (0, 1) by taking 1000 samples of size n = 30. For each sample find the mean x%3Dand then make a histogram of these 1000 values.Procedure - Uniform1. Activate cell A12. Choose the Data tab, then select Data Analysis>Random Number Generation.3. Complete the dialog box.Number of Variables:30Number of Random Numbers:1000Distribution:UniformParameters:Between:O and 1Then click OK.4. Enter the formula = AVERAGE(A1:AD2) in cell AE2 to compute the average of the first sample ofsize 30.5. Activate cell AE2, click the fill handle + in the lower right hand corner and drag to cell AE1000 tofill the column sample means from the 1000 samples.

As per guidelines we will only answer the first three subparts, please repost other subparts for…

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.

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.

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter0: A Review Of Basic Algebra

Section0.CT: Chapter Test

Problem 34CT

See similar textbooks