Calculate the relative and cumulative frequencies

Assignment Help Accounting Basics
Reference no: EM131339755 , Length:

Develop a 750 - 900-word report in which you answer the following:

1.) Calculate the mean, median, mode and standard deviation for all cities for a pizza. Determine the normal distribution curve, showing the costs at 1, 2, and 3 standard deviations above and below the mean. Translate those into Z scores. Discuss why your monthly expenses might vary that much above or below the mean. What is the empirical rule? Does your data fit the empirical rule? Why or why not? If you do not know how to use the Data Analysis Toolpak, you can watch the videos in Week 2. Or you can just create the metrics by using the functions. See this video for that: https://www.youtube.com/watch?v=2rEhWFhSqnI

2.) Use inferential analysis to determine the average cost of eggs, orange juice and coffee in Arizona, Missouri and South Carolina for the population of those states. Explain what makes your approach inferential?

3.) Develop a continous probability distribution table for ground beef for all cities listed. You may create classifications in less than $3.00

$3.01-$3.50

$3.51-$4.00

$4.01-$4.50

$5.00 or morec.

Calculate the relative and cumulative frequencies for each classification.

What is the probability you would have to spend less than $3.50 for a pound of ground meat?

What is the probability that you would have to spend more than $4.50 for a pound of ground meat?

Which classification would you have the greatest probability of buying?

Explain how relative frequencies relate to probabilities?

(If you do not know how to sort values in Excel, refer to this video: https://www.youtube.com/watch?v=IrymK7jx-34

4.) On an ongoing basis, how would probability analysis help you set a budget for the 2nd year you lived in this city?

Format your assignment consistent with APA guidelines.

Attachment:- DataSet.xlsx

Verified Expert

This task provides a brief description on the construction of normal curve in excel. In addition, the workings of descriptive and inferential statistics are also done using excel workings. The construction of frequency table for five classifications of ground beef was done using excel formulas

Reference no: EM131339755

Questions Cloud

Explore respective roles of federal and state authorities : POL110- Analyze the respective roles of Federal and state authorities in addressing the issue. Determine whether the U. S. Constitution constrains the Federal and state responses to the issue. Explain.
Consider a recent program change of the company : Consider a recent program change of the company's financial system that you use every day in your job. You need to learn the new system and you have anxieties about adding this burden to your daily routine while you are learning the system.
Federal government instrument : Which of the following is not a federal government instrument? Which of the following is an example of a mixed instrument?   Which of the following is a dollar denominated deposit held in banks outside the United States? Which of the following would ..
What group of people are you interested in working : What do you hope to achieve by pursuing graduate work in psychology? At this moment in time, what is your purpose? What group of people are you interested in working with and why
Calculate the relative and cumulative frequencies : Calculate the relative and cumulative frequencies for each classification - What is the probability you would have to spend less than $3.50 for a pound of ground meat and what is the probability that you would have to spend more than $4.50 for a poun..
Discuss about the 3-d printing as a manufacturing process : Discuss about the 3-D printing as a manufacturing process.and Net shape or near net shape process,b. Internal cavities and pre-assembly of parts,c. Impact of material choice on hardware cost and operating temperature.
How do similarity and familiarity increase helping : How do similarity and familiarity increase helping? What other factors increase the likelihood of helping? What factors are related to a decreased likelihood to help
Advantage for share repurchases versus dividends : Describe why the way in which they distribute cash flow does not affect value, in perfect markets. Demonstrate how taxes can create an advantage for share repurchases versus dividends. Why are firms in different industries and countries have differen..
Identify an organization enterprise or small-medium business : Identify an organization (enterprise or small-medium business). Assess the security vulnerabilities of the organization's computing systems along with the techniques used to protect them.

Reviews

inf1339755

1/6/2017 5:19:30 AM

Dear ExpertsMind.com... I want to show my appreciation for your service through this email. Presently I know who to trust when employing to composing papers - ExpertsMind.com. At the end of the day much obliged.

Write a Review

Accounting Basics Questions & Answers

  Determine amos seagull gross income

Determine Amos Seagull's gross income in each of the following cases:

  On march152011birkshire energy obtained a nine-month

on march152011birkshire energy obtained a nine-month working capital loan from the first national bank of oglesby. the

  On december 31 2013 prepare the adjusting entry to record

ryder company which began operations in 2011 invests its idle cash in trading securities. the following transactions

  Schedule of cash collections sugarland company sells a

schedule of cash collections sugarland company sells a single product and anticipates opening a new facility in

  Calculate the real risk-free rate of return

30-day T-bills are currently yielding 8 percent. Current interest rate premiums: Inflation premium: 5%  Liquidity premium: 1%  Maturity risk premium: 2%:  Default risk premium: 2% Calculate the real risk-free rate of return.

  Purchased on credit space for classied advertisements in

sleek ride a company providing limo services has a december 31 year-end date. for sleek ride the following transactions

  The purchase of store supplies on account

The purchase of store supplies on account for $1,570 was recorded as a debit to Store Supplies $1,750 and a credit to Accounts Payable $1,750.

  Wtches inc makes a watch selling for 50 per unit

watches inc. makes a watch selling for 50 per unit. operating within its relevant range they have excess capacity to

  Why is one product line preferred over the other even

bath works products company is considering an investment in one of two new product lines. the investment required for

  Does it use the direct write off method or allowance method

Refer to the balance sheet of Arctic Cat in Appendix A.

  Analyze what portion of each distribution is a dividend

Analyze what portion of each distribution is a dividend.

  Provide a brief numerical example that would indicate why a

discuss how depreciation is calculated under the straight-line units-of-production and double-declining-balance

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