Reference no: EM131031960
Download dataset: Dataset I: Noodles & Company Database from Blackboard
1. Descriptive Statistics: Calculate mean, median, variance and standard deviation for average salad sales for each month by using Excel functions.
2. Histogram: Draw the histogram of "Average Daily Rice Krispy Sales" for June.
a. State the number of bins, lower and upper limits of each bin, and calculate the relative frequency for each bin. Explain how you determine the appropriate number of bins.
b. Create a table stating each bin, upper and lower bin limits, and relative frequencies clearly.
c. Use the table you have created in part (b) to draw a histogram. Do not forget to label the axes, the table, and the histogram. Include the table and the histogram in both documents.
3. Covariance and Correlation Coefficient: Calculate the covariance and the correlation coefficient between "Sales Growth over Previous Year (%)" and "Change in Average Service Time (Min)" by using Excel functions. State the unit of measurement for each statistic and explain what these numbers mean (the direction and the magnitude of the correlation if there is any).
4. Confidence Interval:
a. Choose a random sample of 20 restaurants for "Sales per Person."
b. Calculate the mean and standard deviation for this random sample.
c. Assume that population standard deviation is unknown. Calculate the confidence interval for population mean by using the sample mean and sample standard deviation for 90%, 95% and 99% confidence levels.
d. Assume that the dataset you have represents the whole population. Calculate the standard deviation of the population and use it to calculate the confidence interval for the population mean for the same random sample for 90%, 95% and 99% confidence levels.
Attachment:- dataset-i-noodles-company-database.rar
|
Indicate that both processes yield the same mean level
: Reading down and left to right, draw a time series plot of all the data and comment on any features of the data that are revealed by this plot.
|
|
Why is health literacy particularly important to this group
: Defines health literacy and explains its relationship to health outcomes; (body paragraph) Define health literacy and explain why is it important (eg what happens when people have low levels of health literacy, how common is low health literacy et..
|
|
Determining the center of gravity
: The circular plate has a weight W and center of gravity at its center. If it is supported by three vertical cords tied to its edge, determine the largest distance d from the center to where any vertical force P can be applied so as not to cause th..
|
|
The trial balance of valdez fashion center
: The trial balance of Valdez Fashion Center contained the following accounts at November 30, the end of the company’s fiscal year.
|
|
Calculate the standard deviation of the population
: Assume that the dataset you have represents the whole population. Calculate the standard deviation of the population and use it to calculate the confidence interval for the population mean for the same random sample for 90%, 95% and 99% confidence..
|
|
How far is the kid from the stop sign
: A kid a kid is flying a kite with all 80 feet of string out.The kite is 35 feet above a stop sign.How far is the kid from the stop sign.
|
|
Determine the location
: Determine the location x and y of the point of application of force P so that the tension developed in cables AB, CD, And EF is the same. Neglect the weight of the plate.
|
|
Find the value of p such that the probability
: what is the probability that in any one year a mammogram will produce a false-positive result? (Hint: Find the value of p such that the probability that a binomial random variable with n = 10 is greater than or equal to 1 is .60.)
|
|
Identify any potental natural hazards in your area
: What have you done to be prepared? Identify evacuation routes, which will not be effected by the hazard. Do you know where gas and electrical shut off valves are? Do you have a plan with you family encase you are separated? Do you have a disaster ..
|