Please help to find the correct EXCEL FORMULA for the t-value. Please make sure to give the correct EXCEL FORMULA. Thanks! ReviewViewHelpO Editing vArialv 11B AvE a6 Merge vGeneral00B12fr =T.DIST.2T(0.05,B11-1)00ABEFGHSuppose that a popular museum is interested in estimating the average age of summer visitors. A random sample of summervisitors is selected. The data is recorded in tab "Age",23.The researchers want to determine a 95% confidence interval around the mean weight of all summer visitors.6 Required:Determine the following:Mean7838.3125OIn13.41986371 02.372319158O32 00.960443165 XStandard Deviation10 Standard Error11 Sample Size12 t-ValueLec13need14 Margin of Error without using Confidence.t154.838376821worksp16 Now compute the Margin of Error using Confidence.t1718 Upper Bound Confidence Interval19 Lower Bound Confidence Interval202122 ReviewViewHelpO Editing vAnalAMerge vGeneral$v 、@、屏B12fx =T.DIST.2T(0.05,30)00BDFGSuppose that a popular museum is interested in estimating the average age of summer visitors. A random sample of summerMcGra2visitors is selected. The data is recorded in tab "Age".CheckThe researchers want to determine a 95% confidence interval around the mean weight of all summer visitorsx YourRequired:Determine the following:8 MeanStandard Deviation10 Standard ErrorQuestion38.3125 OIntegrated Exc13.4198637102.372319158 CLegend11 Sample Size12 t-Value320.960453809 XGraded cell L13needed.14 Margin of Error without using Confidence.tScratchpad Use154.8383768210workspace16 Now compute the Margin of Error using Confidence.t1718 Upper Bound Confidence Interval19Lower Bound Confidence Interval2021Contaun

Step 1 Here is given that, mean is 38.3125 standard deviation is 13.4199 And sample number is 32. We…

Answered: Please help to find the correct EXCEL…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The article “Arsenic and Mercury in Lake Whitefish and Burbot Near the Abandoned Giant Mine on Great Slave Lake” (P. Cott, B. Zajdlik, et al., Journal of Great Lakes Research, 2016:223–232) presents measurements of arsenic concentrations in fish found in Northern Canada. a) In a sample of 8 whitefish caught in Yellowknife Bay, the mean arsenic concentration in the liver was 0.32 mg/kg, with a standard deviation of 0.05 mg/kg. Find a 95% confidence interval for the concentration in whitefish found in Yellowknife Bay. b) In a sample of 8 whitefish caught in Baker Pond, the mean arsenic concentration in the liver was 0.55 mg/kg, with a standard deviation of 0.36 mg/kg. Should the Student’s t distribution be used to find a 95% confidence interval for the concentration in whitefish found in Baker Pond? If so, find the confidence interval. If not, explain why not.
During a natural gas shortage, a gas company randomly sampled residential gas meters in order to monitor daily gas consumption. On a particular day, a sample of 100 meters showed a sample mean of 250 cubic feet and a sample standard deviation of 50 cubic feet. Provide a 90% confidence interval estimate of the mean gas consumption for the population.
From a stand of eucalyptus, 25 trees were drawn and their diameters were determined, in cm, in order to estimate the mean diameter of the stand. These diameters were: a) Based on this sample, calculate the 90% and 95% confidence intervals for the population mean.b) Obtain the 95% confidence interval for population variance.
Prison Sentences. Researchers M. Dhami et al. discussed how people adjust to prison life in the article “Adaption to Imprisonment” (Criminal Justice and Behavior, Vol. 34, No. 8, pp. 1085–1100). A sample of 712 federally sentenced adult male prisoners had an average sentence of 9.15 years. Assume that, for federally sentenced adult male prisoners, the population standard deviation of sentence length is 17.2 years. a. Find and interpret a 90% confidence interval for the mean sentence length, μ, of all federally sentenced adult male prisoners. b. Under what conditions can you freely apply the procedure that you used in part (a)?
Construct a 90% confidence interval for μ1−μ2 with the sample statistics for mean cholesterol content of a hamburger from two fast food chains and confidence interval construction formula below. Assume the populations are approximately normal with unequal variances.
A random sample of male and female employees selected from a large industrial plant yielded the followinghourly wage results (in Rands):Male Femalen1 = 45 n2 = 32x1 = 6.00 x2 = 5.75s1 = 0.95 s2 = 0.75Question 1Calculate the difference in the sample means (rounded off to two decimals)? Question 2Construct and explain a 99% confidence interval for the difference between the population mean hourlywages for all male and female employees (rounded off to four decimals). Question 3Is there a significant difference in the two population means, considering the confidence interval found inQuestion 2?
A large automobile insurance company selected samples of single and married male policy-holders and recorded the number who made an insurance claim over the preeding three-year period. Male Policy Holders: Single Married Sample size 400 900 No. Making claims 76 90 Conduct a hypothesis test to determine whether there is a difference in proportion of claims between single and married male policy holders. Use a 0.05 level of significance Provide a 95% confidence interval for the difference between the proportions for the two populations. Suppose now that we also have data on the number of claims by male retirees. The data are now: Male policy holders: Single Married Retirees No. Making claims 76 90 45 Sample size 400 900 250 Assume that the three categories are mutually exclusive. Using a 0.05 significance level and a critical value approach, conduct an appropriate test to determine if there is a significant…
A gardener is testing a new type of carrot. From a sample of 15 carrots, she calculates a mean length of 7.2 inches and standard deviation of 1.23 inches. Find a 95% confidence interval for the mean length of this new type of carrot.

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS