User Account

All Pages

Cake mix assignment data workbook

Assignment Help Basic Statistics
Reference no: EM131090195

Question:

Continue using the Cake Mix Assignment Data workbook.

Use a new Excel workbook file for this assignment.

  1. Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of the new Excel workbook.
  2. Enter the following labels in cells A34:A36: Point Estimate, Lower bound of the 95% Confidence Interval, and Upper Bound of the 95% Confidence Interval. Adjust the width of column A, as needed, to accommodate labels without truncation.
  3. Use the cake mix data as a random sample of all grocery store cake mixes in order to estimate the population mean for sugar grams. Accordingly, calculate the point estimate of the population mean of variable "Sugar grams" by entering the appropriate formula in cell B34. Adjust cell format to round to two decimal places.
  4. Calculate the Lower Bound of the 95% Confidence Interval of the population mean for variable "Sugar grams" by entering the appropriate formula in cell B35 (assume the population standard deviation equals the sample standard deviation). Adjust cell format to round to two decimal places. (HINT: use the normal distribution to obtain the critical value for a 95% confidence interval.)
  5. Calculate the Upper Bound of the 95% Confidence Interval of the population mean for variable "Sugar grams" by entering the appropriate formula in cell B36 (assume the population standard deviation equals the sample standard deviation). Adjust cell format to round to two decimal places. (HINT: use the normal distribution to obtain the critical value for a 95% confidence interval.)
  6. Enter your interpretation of the 95% confidence interval in cell B37 (i.e., what are you 95% confident about?).
  7. Describe the hypothetical effect of sample size on the width of a confidence interval in cell B38. (Note: Wrap text and/or use adjacent cells as needed.

Reference no: EM131090195

Questions Cloud

Project classroom makeover : The reading "project classroom makeover" is in the attachement the introduction paragraph should have one thesis sentence in the last sentence in the introduction paragraph for the body paragraphs, each body paragraph should have:
Explain any conclusions or insights you have about gender : Pick one culture that is different from your own in terms of expectations of emotion and gender. Explain how emotional expression is similar and different for this culture.
Sketch of the normal curve : What height is at the 35th percentile? Include an appropriately labeled sketch of the Normal curve to support your answer.
Write a main program that outputs temperature : Organize the software interface into a device driver, and write a main program that outputs temperature to the SCI channel.
Cake mix assignment data workbook : Copy the Assignment Data (i.e., cake mix data) to Sheet 1, cells A1:P32, of the new Excel workbook. Enter the following labels in cells A34:A36: Point Estimate, Lower bound of the 95% Confidence Interval, and Upper Bound of the 95% Confidence Inter..
Design a wind direction measurement instrument : Write the ritual and gadfly function/subroutine that measures the wind direction and returns a 16-bit unsigned result with units of degrees (i.e., the value varies from 0 to 359). (You do not have to write software that samples at 1 Hz, simply a f..
Standard deviation sigma equals : Assume that adults have IQ scores that are normally distributed with a mean of mu equals 100 μ=100 and a standard deviation sigma equals 15σ=15. Find the probability that a randomly selected adult has an IQ less than 121121.
How could you change the above program to prevent deadlock : How could you change the above program to prevent the deadlock?
Standard deviation of the minimum temperature : Suppose the standard deviation of the minimum temperature in February is 6 degrees Upper F6°F and that the distribution of minimum temperatures in February is approximately Normal.

Reviews

Write a Review

Basic Statistics Questions & Answers

  1a study was conducted to explore the relation between

1.a study was conducted to explore the relation between alcohol consumption and hypertension. 7400 nurses were surveyed

  Actions to improve the repair time of equipment used to

actions to improve the repair time of equipment used to produce electronic components were taken two years ago. the

  Probability for the number of students in sample

Develop a probability for the number of students in the sample who watch soap operas.

  Simple random sample of annual incomes of adults

[1] Assume that we collect a large (n> 30) simple random sample of annual incomes of adults in the United States.  Because the sample is large, can we approximate the distribution of these incomes with a normal distribution?  Why or why not?  Expl..

  Smoothness of the ?tted curve

Using the constant a 5 0.3, ?t an exponentially smoothed curve to the original time series. Repeat part (c) using a 5 0.7. How has the new value for the constant affected the smoothness of the ?tted curve?

  Sample mean hypothesis testing

Imagine that you have a portfolio of stocks. You want to compare the performance of your stocks to the market as a whole. You learn that the population mean,μ, of stock returns is 7%, and that the population standard deviation, σ, is 2%.

  Are mean annual attendance rates same for employees

The sample sizes are unequal. Research question: Are the mean annual attendance rates the same for employees in these three departments?

  What is the probability of a type ii error if the true

a researcher concerned about the foreign ownership of the retail trade industry in the u.s. conducts a survey of

  Determine the motion of the mass

Determine the motion of the mass. Decribe its motion in as much detail as possible.

  Probability that shaft selected at random lie in range

The average shaft size for the E300 electric motor is .55 inch, with a standard deviation of .10 inch. It is normally distributed. What is the probability that a shaft selected at random will be between .55 and .65 inch?

  The population of iq scores forms a normal distribution

the population of iq scores forms a normal distribution with a mean of micro 100 and a standard deviation of ? 15.

  Determine shortest time spent waiting for heart

Determine the shortest time spent waiting for a heart that world still place a patient in the top 10% of waiting times? In days?"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd