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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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