Question

In: Statistics and Probability

Compute the weighted average (round to the nearest cent) for the following table of values: x...

Compute the weighted average (round to the nearest cent) for the following table of values:

x f(x)
$ 5 25
$ 20 11
$ 30 8
$ 75 3
$ 100 1

Also, what is the median dollar value from this data?

Compute the geometric mean return (rounded to 4 decimal places) for the following:

Year Return
1 15%
2 -20%
3 30%
4 -8%
5 25%

If you invested $1,200, how much would it be worth after 5 years (round to the nearest cent)?

When you answer the question put the 4 answers first, in this order and label like this:

Weighted Average:

Median value from the weighted average problem:

Geometric Mean Return:

What would be the value of $1,200:

And then explain the difference between weighted average and geometric mean.

Solutions

Expert Solution

Weighted average:

Weighted average, =[x.f(x)]/f(x) =[(5*25)+(20*11)+....+(100*1)]/(25+11+8+3+1) =(125+220+240+225+100)/48 =910/48 =$18.96

Median:

x f(x) Cumulative frequency
5 25 25
20 11 25+11 =36
30 8 36+8 =44
75 3 44+3 =47
100 1 47+1 =48
48

f(x)/2 =48/2 =24

24 is less than the cumulative frequency of 25 where $5 is present.

Therefore, Median, M =$5

Geometric mean return:

Geometric mean return, GM =[(15)(-20)(30)(-8)(25)]1/5 =17.8260%

Future VALUE (FV) of $1200:

FV =PV(1+r)n

Let the rate of interest, r =10% =0.10

Given: n =5 years; Present value, PV =$1200

Thus, FV =1200(1+0.10)5 =$1932.61

Answers:

Weighted Average: $18.96

Median value from the weighted average problem: $5

Geometric Mean Return: 17.8260%

What would be the value of $1,200: $1932.61


Related Solutions

Compute the weighted average (round to the nearest cent) for the following table of values: x...
Compute the weighted average (round to the nearest cent) for the following table of values: x f(x) $ 5 25 $ 20 11 $ 30 8 $ 75 3 $ 100 1 Also, what is the median dollar value from this data? Compute the geometric mean return (rounded to 4 decimal places) for the following: Year Return 1 15% 2 -20% 3 30% 4 -8% 5 25% If you invested $1,200, how much would it be worth after 5 years...
Compute the total annual tax for the following individuals. Note: Round each to the nearest cent....
Compute the total annual tax for the following individuals. Note: Round each to the nearest cent. Alex has self-employment earnings of $55,600. Alex's 2019 total self-employment withholding is: $ Hope has self-employment earnings of $135,000. Hope's 2019 total self-employment withholding is: $ Michelle has self-employment earnings of $220,000. Michelle's 2019 total self-employment withholding is: $ Compute the following for John who is both an employee and self-employed. Note: Round the answer to the nearest cent. John worked for the NFL,...
using excel functions Complete the following without a table (round each calculation to the nearest cent...
using excel functions Complete the following without a table (round each calculation to the nearest cent as needed): 1. principal time rate of compounding interest   compounded NUMBER of periods compounded total amount Total interest $ 500   1 year 8% quarterly A. ? B. ? C.? Solve the previous problem by using compound value (FV). See Table 12.1. Lionel Rodgers deposits $7,000 in Victory Bank, which pays 4% interest compounded semiannually. How much will Lionel have in his account at the...
Find the average total cost for producing 32 sneakers. Round your answer to the nearest cent.
The table below represents the costs of producing sneakers.QuantityFixed CostVariable CostTotal CostAverage Fixed CostAverage Variable CostAverage Total Cost8$117$10$127???16$117$60$177???24$117$110$227???32$117$160$277???40$117$210$327???Find the average total cost for producing 32 sneakers. Round your answer to the nearest cent.Provide your answer below:
Use the transactions below to answer the following questions. Round to the nearest cent for per...
Use the transactions below to answer the following questions. Round to the nearest cent for per unit cost and the nearest dollar for the totals for COGS, Ending Inventory and Gross Profit. Date Quantity Unit Cost Sale Price Mar 1 Beginning Inventory 30 $30 Mar 4 Purchase 40 $28 Mar 8 Sale 35 $54 Mar 15 Purchase 50 $26 Mar 20 Sale 42 $55 Using the LIFO Method for inventory costing calculate the following amounts for the month of March....
For all payroll​ calculations, use the following tax rates and round amounts to the nearest​ cent:...
For all payroll​ calculations, use the following tax rates and round amounts to the nearest​ cent: ​Employee: ​OASDI: 6.2​% on first $132,900 ​earned; Medicare: 1.45​% up to $200,000​, 2.35​% on earnings above $200,000. ​Employer: ​OASDI: 6.2​% on first $132,900 ​earned; Medicare: 1.45​%; ​FUTA: 0.6​% on first $7,000 ​earned; SUTA: 5.4​% on first $7,000 earned. Robinson works at College of Boston and is paid $30 per hour for a​ 40-hour workweek and​ time-and-a-half for hours above 40. For all payroll​ calculations,...
The problem describes a debt to be amortized. (Round your answers to the nearest cent.) A...
The problem describes a debt to be amortized. (Round your answers to the nearest cent.) A man buys a house for $340,000. He makes a $150,000 down payment and amortizes the rest of the purchase price with semiannual payments over the next 5 years. The interest rate on the debt is 10%, compounded semiannually. (b) Find the total amount paid for the purchase.
Please round to the nearest cent for all answers. --------------------------------------------------------------------------------- Compare the monthly payment and total...
Please round to the nearest cent for all answers. --------------------------------------------------------------------------------- Compare the monthly payment and total payment for the following pairs of loan options. Assume that both loans are fixed rate and have the same closing costs. You need a ​$160,000 loan. Option​ 1: a​ 30-year loan at an APR of 7.25%. Option​ 2: a​ 15-year loan at an APR of 6.8%. ---------------------------------------------------------------- Find the monthly payment for each option. The monthly payment for option 1 is​what. The monthly payment...
Prepare an income statement that more accurately reflects the division's profit performance. Round intermediate calculations to the nearest cent. Round final answers to the nearest dollar.
Keep or Drop a DivisionJan Shumard, president and general manager of Danbury Company, was concerned about the future of one of the company's largest divisions. The division's most recent quarterly income statement follows:Sales$3,751,500Less:Cost of goods sold2,722,400Gross profit$1,029,100Less:Selling and administrative expenses1,100,000Operating (loss)$ (70,900)Jan is giving serious consideration to shutting down the division because this is the ninth consecutive quarter that it has shown a loss. To help him in his decision, the following additional information has been gathered:The division produces one...
Find the present value PV of the given investment. (Round your answer to the nearest cent.)...
Find the present value PV of the given investment. (Round your answer to the nearest cent.) An investment earns 3% per year and is worth $80,000 after 8 years. PV=
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT