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

  Population mean weight of adult mud turtles

A biologist has found that the average weight of 12 randomly selected adult mud turtles is 8.7 lb. with standard deviation 3.6 lbs. Construct a 99% confidence interval for the population mean weight of adult mud turtles.

  Pascal triangle and probability

Describe a real-life situation where Pascal's Triangle can be used to calculate probability. Is this the best method for solving your calculation?

  Test statistics and stated life of battery was significant

The test question was if this difference between the test statistics and the stated life of the battery was significant? The .05 significant level was selected for the test. Which is the correct statement?

  Random sample of working days

The following data represents the amount of time in minutes that a person had to wait for a bus to work on a random sample of 5 working days.

  From the following stem-and-leaf display find the minimum

from the following stem-and-leaf display find the minimum value the 1stquartile the median the 3rdquartile and the

  How to conclude that hypothesis should be rejected

A random sample of doctors was taken suppose the test statistic is z= -1.95. can we conclude that h0 should be rejected at the 1) a=.10 b) a=0.05 c) a= 0.01 level?

  Calculation of simple regression

Work through a simple regression calculation using intrinsic job satisfaction nd extrinsic job satisfaction. Select thirty data points to use for each group.

  Probability and stochastic processes

The count of students dropping the course "Probability and Stochastic Processes" is known to be a Poisson process of rate 0.1 drops per day. Starting with day 0, the first day of the semester, let D(t) denote the number of students that have dropp..

  Why do you use the chi-square statistic what type of data

why do you use the chi-square statistic? what type of data is used with chi-square anaylisis? what are the

  Probabilities of ncaa basketball tournament

NCAA Basketball Tournament. Each year, 64 college basketball teams compete in the NCAA tournament. Sandbox.com recently offered a prize of $10 million to anyone who could correctly pick the winner in each of the tournament games.

  Probability-parts manufactured on a company

According to Fortune, Missouri is within 500 miles of 44% of all U.S. manufacturing plants 8. If a Missouri company needs parts manufactured in 122 different plants, what is the probability that at least half of them can be found within 500 miles ..

  Determine if this study is experimental or observational

1. determine if this study is experimental or observational researchers monitor the health of smokers and

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