Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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.

image text in transcribedimage text in transcribed
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 ofthe 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: 0 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) 0 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 a? 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 AEZ, click the fill handle + in the lower right hand corner and drag to cell AElOOO to fill the column sample means from the 1000 samples. 6. Create a histogram of the means: Using Mega Stat or Excel. For Excel: Make sure to select the column containing the sample means and check the box for Chart Output - leave the Bin Range box blank. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Interconnection Networks

Authors: J C Bermond

1st Edition

1483295273, 9781483295275

More Books

Students also viewed these Mathematics questions

Question

Eliminate street slang.

Answered: 1 week ago

Question

Steps: Proof by contrapositive that if n21 is even, then n is odd

Answered: 1 week ago

Question

Values: What is important to me?

Answered: 1 week ago

Question

Purpose: What do we seek to achieve with our behaviour?

Answered: 1 week ago