User Account

All Pages

Construct a frequency distribution table

Assignment Help Financial Management
Reference no: EM131876975

Complete the following for the sets of data in the spreadsheet (all 10 will be found on different sheets in the single file):

a) Construct a frequency distribution table. Be sure to include the frequency, relative frequency, cumulative frequency, and class midpoints. I have provided enough information so that everyone should be able to come up with the same classes for all the problems.

b) Find the mean, median, mode, variance and standard deviation for all of the data sets.

Make sure you DO NOT ONLY USE THOSE SPECIFIC EXCEL FORMULAS; be sure to use the techniques that were displayed in class so that I have the opportunity to verify you know what each of the formulae is doing. It IS PERMISSIBLE to use the excel formulae as a check, but that should not be your only answer.

c) For four of the data sets (any four you choose) create and display one of each type of the following charts: pie, line, bar, box and whisker. For the box and whisker graph, be sure to include for that data set the five number summary and the IQR.

d) For all of the data sets, compute the 90th and 27th percentiles. Also, for each data set, find the percentile value for the datum (singular of data) that is 8 places above the median, and for the datum that is 12 places below the median.

e) From each set of data, standardize any 6 scores you choose.

Attachment:- Assignment Data.rar

Reference no: EM131876975

Questions Cloud

Barriers to entry for a single-price monopolist : Choose two (2) barriers to entry for a single-price monopolist, give an example of each, and explain how they serve as a barrier to entry for other firms.
What are some key differences between the two : What are some key differences between the two? Discuss the three steps to follow when trying to distinguish between kinds of deductive arguments.
What happens to the rental rate of land : What happens to the rental rate of land? Explain your answer using the graph for the equilibrium in the specific-factor model.
What is escheatment and what are state laws : What is escheatment and what are state laws and regulations on abandoned or unclaimed payroll funds
Construct a frequency distribution table : Find the mean, median, mode, variance and standard deviation for all of the data sets.
Why an initial change in aggregate demand : Explain carefully why an initial change in aggregate demand will shift the aggregate demand function by a multiple of the initial change in output.
Gifts that better conform with their wishes : Assume you are an economist charged with advising Santa Claus and Santa, concerned about consumer satisfaction, tells you that he wants
What your impressions when you listen to traditional music : What are your impressions when you listen to traditional Kyrgyzstan music and watch the video provideas part of course where you are able to see modern cities.
Total utility and marginal utility : How does the distinction between Total Utility and Marginal Utility help one answer this question? Might the Diamond-Water Paradox

Reviews

Write a Review

Financial Management Questions & Answers

  Provide information to managers for decision-making purposes

How can balanced scorecard be used to provide information to managers for decision-making purposes?

  Correct for bond currently selling at a premium

Which one of the following must be correct for a bond currently selling at a premium?

  Closed-end mutual fund at its initial public offering

Suppose you purchase 14,500 shares of a closed-end mutual fund at its initial public offering; the offer price is $10 per share. The offering prospectus discloses that the fund promoter gets a fee of 4 percent from the offering. If this fund sells at..

  Current yield-yield to maturity and capital gains yield

Current yield, capital gains yield, and yield to maturity Hooper Printing Inc. has bonds outstanding with 9 years left to maturity. The bonds have an 9% annual coupon rate and were issued 1 year ago at their par value of $1,000. However, due to chang..

  What is the difference in their offers in terms of dollars

Your computer manufacturing firm must purchase 11,000 keyboards from a supplier. One supplier demands a payment of $121,000 today plus $11 per keyboard payable in one year. Another supplier will charge $23 per keyboard, also payable in one year. The ..

  Paying annual dividends

Diets For You announced today that it will begin paying annual dividends next year. The first dividend will be $0.12 a share. The following dividends will be $0.15, $0.20, $0.50, and $0.60 a share annually for the following 4 years, respectively. Aft..

  What is the amount of each mortgage payment

The McDonald Group purchased a piece of property for $1.5 million. It paid a down payment of 20% in cash and financed the balance. The loan terms require monthly payments for 15 years oat an annual percentage rate of 5% compounded monthly. What is th..

  After the capital structure change

Suppose, additionally, that the beta of the unlevered stock was 0.60. What will ßA, ßD, and ßE be after the capital structure change?

  Preferred stock-market and common stock

The Saunders Investment Bank has the following financing outstanding. Debt: 30,000 bonds with a coupon rate of 6 percent and a current price quote of 112; the bonds have 20 years to maturity. 200,000 zero coupon bonds with a price quote of 21 and 30 ..

  Try to determine the required rate of return

Try to determine the required rate of return on Tilden Woods Corporation’s common stock. The firm’s beta is 0.94.

  What has occurred with companys dividend payout

What has occurred with companys dividend payout, dividend yield, and dividend per share over the past three years -  Do you have any explanations for what has occurred? How does your selected company's dividend payout, dividend yield, and dividend p..

  Significant limitations in managing interest rate risk

Explain the following statements and is true statment? Duration tools have significant limitations in managing interest rate risk. Asset/Liability managers will prefer that assets be more convex than liabilities.

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