You will need the same dataset used for problem 3 in homework I the dataset obtained...

Transcribed Image Text:

You will need the same dataset used for problem 3 in homework I the dataset obtained from the yahoo website with the company you selected). Use Excel to calculate the average and standard deviation of the close data column. Assume that these two numbers represent the population (=parametric) mean and population standard deviation, respectively, for the variable length (in cm) in a population of a species of fish. Attach a printout of the data to your homework and write down the ticker code on it. a. Calculate the probability of sampling at random a fish that is smaller in size than the value you would obtain by subtracting half the standard deviation from the average [x will be equal to: - (/2)] b. Calculate the probability of sampling at random a fish that is greater in size than the value you would obtain by adding half the standard deviation from the average [x=+(0/2)] c. Calculate the probability of sampling at random a fish that has a size between the two values [x=- (o/2), x=+(6/2)] used in parts "a" and "b," respectively d. Calculate the 25th and 75th percentiles of fish size for the population using the normal distribution table. Tesla Question 3 TSLA Dec 1 365.00 Dec Dec 2 361.53 Dec 3 338-32 356-32 Dec 9 334.60 Declo 339.01 Decis Dec 16 325.33 30597 Dec 16 336.34 Dec 13 32244 Dec 12 310.56 Dec 7 350.58 Dec 14 319.50 Dec zo. 299.98 -Decal 312-84 Dec 27 376-29 Dec 23 355.67 Dec 27 364165 Dec 28 e. Imagine that 5 individuals are sampled at random from this fish population. Calculate the probability that the average calculated will be less than the 362-82 Dec 29. Dec 30 367.06 356.78 with Com Connor You will need the same dataset used for problem 3 in homework I the dataset obtained from the yahoo website with the company you selected). Use Excel to calculate the average and standard deviation of the close data column. Assume that these two numbers represent the population (=parametric) mean and population standard deviation, respectively, for the variable length (in cm) in a population of a species of fish. Attach a printout of the data to your homework and write down the ticker code on it. a. Calculate the probability of sampling at random a fish that is smaller in size than the value you would obtain by subtracting half the standard deviation from the average [x will be equal to: - (/2)] b. Calculate the probability of sampling at random a fish that is greater in size than the value you would obtain by adding half the standard deviation from the average [x=+(0/2)] c. Calculate the probability of sampling at random a fish that has a size between the two values [x=- (o/2), x=+(6/2)] used in parts "a" and "b," respectively d. Calculate the 25th and 75th percentiles of fish size for the population using the normal distribution table. Tesla Question 3 TSLA Dec 1 365.00 Dec Dec 2 361.53 Dec 3 338-32 356-32 Dec 9 334.60 Declo 339.01 Decis Dec 16 325.33 30597 Dec 16 336.34 Dec 13 32244 Dec 12 310.56 Dec 7 350.58 Dec 14 319.50 Dec zo. 299.98 -Decal 312-84 Dec 27 376-29 Dec 23 355.67 Dec 27 364165 Dec 28 e. Imagine that 5 individuals are sampled at random from this fish population. Calculate the probability that the average calculated will be less than the 362-82 Dec 29. Dec 30 367.06 356.78 with Com Connor