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

  The weight of the cereal in a box is a random variable with

the weight of the cereal in a box is a random variable with mean 12.15 ounces and standard deviation 0.2 ounce. what

  Intramodal and intermodal competition

Explain the difference between intramodal and intermodal competition in the rail- road industry. Which form of competition is most beneficial to shippers? Why?

  Hypothesis testing of new york times

The New York Times recently reported that 60% of college entrants into elite public and private colleges in the U.S. have parents that earn over $150,000/yr.

  A set of 4 numbers is selected at random from s 12345678

a set of 4 numbers is selected at random from s 12345678 without replacement. what is the probability thata exactly 2

  What is meant by autocorrelation

What is meant by autocorrelation and draw a figure showing positive and negative first- order autocorrelation.

  A datset is provided on a 3 factor factorial on the amount

a datset is provided on a 3 factor factorial on the amount of rot on a potatoe crop. the variables aretype of

  The following are the numbers of defective parts produced

the following are the numbers of defective parts produced in a shift by 10 workers before and after going through a

  Insurance business problems and statistics

Choose any Statistic business problem and develop a problem statement which can be addressed with survey research. Prepare a 10-13 question survey to collect primary data regarding your selected problem statement.

  Simple random sampling-cluster sampling

Compare the differences of Simple random sampling & Cluster sampling using specific examples, and show the pros and cons of each method.

  The financial department at a large hospital would like to

the financial department at a large hospital would like to estimate the average outstanding balance owed by patients

  In a survey of women in a certain country ages 20-29 the

in a survey of women in a certain country ages 20-29 the mean height was 64.1 inches with a standard deviation of 2.99

  Another archer is shooting 4 arrows at a target in each

a an archer is shooting 8 arrows at a target. in each shot his probability of hitting the target equals 0.4. what is

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!

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