Question

In: Advanced Math

1. Calculate the weighted averages for two additional used cars using the weights given in the...

1. Calculate the weighted averages for two additional used cars using the weights given in the table below.

New weights

Car 4 Ratings

Car 5 Ratings

Reliability

5

7

6

Gas Mileage

6

5

7

Interior Features/Comfort

10

8

7

Cargo Space

4

6

8

Make sure that you fill in each answer area before checking "How Did I Do?".

  1. Weighted average for Car 4:  
  2. Weighted average for Car 5:   
  • In your weighted average equations in the problem above, how many total weights are used?


  • For each category, what percent of the total weights are represented by the category weights? Enter your answers in the table.

    New Weights as a Percentage of Total Weights

    Reliability

    %

    Gas Mileage

    %

    Interior Features/Comfort

    %

    Cargo Space

    %

  • In the tables below, multiply each category’s percentage weight by its rating, and add up the four amounts.

    Percentage Weights (written as a decimal)

    Car 4 Ratings

    Reliability

    ×

    7

    =

    Gas Mileage

    ×

    5

    =

    Interior Features/Comfort

    ×

    8

    =

    Cargo Space

    ×

    6

    =

    Total



    Percentage Weights (written as a decimal)

    Car 5 Ratings

    Reliability

    ×

    6

    =

    Gas Mileage

    ×

    7

    =

    Interior Features/Comfort

    ×

    7

    =

    Cargo Space

    ×

    8

    =

    Total


  • Write an equation for the weighted average using the percentage weights as decimals. Use the following variables to represent the individual rating in each category: R= Reliability; G= Gas Mileage; I= Interior Features/Comfort; C= Cargo Space.

    Weighted average =

Solutions

Expert Solution

Weighted average can be calculated as the Sum of the product of individual weights and Ratings and divide the result by the total number of individual weights.

Substituting the values For Car4, we get:

(7*5 + 5*6 + 8*10 + 6*4)/4 = (35 + 30 + 80 + 24)/4 = (169)/4 = 42.25

Hence, The weighted average for Car 4 is 42.25

Similarly, for Car 5, we get:

(6*5 + 7*6 + 7*10 + 8*4)/ = (30 + 42 + 70 + 32)/ 4 = (164)/4 = 41.00

Hence The weighted average for Car 5 is 41.00

To calculate the weights as a result of percentage of total weights, first you require the sum of all new weights:

5 + 6 + 10 + 4 = 25

Hence the total weight is 25.

We can now find the percentage of each individual weight against the total weight:

Reliability = (weight of reliability) / (total weight) * 100 = 5 / 25 * 100 = 0.20 = 20%

Calculating this for all weights, we get:

Reliability 20%
Gas mileage 24%
Interior Features/comfort 40%
Cargo space 16%

Using the above calculated percentages, we can fill the third table (for Car 4) as:

Percentage Weights (written in decimal) Car 4 rating
Reliability 0.20 x 7 = 1.4
Gas mileage 0.24 x 5 = 1.2
Interior Features/comfort 0.4 x 6 = 2.4
Cargo space 0.16 x 6 = 0.96
Total 5.96

Similarly the table for Car 5,

Percentage Weights (written in decimal) Car 5 rating
Reliability 0.20 x 6 = 1.2
Gas mileage 0.24 x 7 = 1.68
Interior Features/comfort 0.40 x 7 = 2.8
Cargo space 0.16 x 8 = 1.28
Total = 6.96

In general, the formula for finding the weighed average using percentage as decimals would be:

Weighted average = R*0.20 + G*0.24 + I*0.40 + C*0.16


Related Solutions

Questions are as shown. NO additional information was given. 1. Calculate the f.e.m. for the following...
Questions are as shown. NO additional information was given. 1. Calculate the f.e.m. for the following reaction at 25oC Li+(aq) (1.8e-4M) +   2Cl-(aq) (6.9e-2M)      →   Li(s) ( - M) +   Cl2(g) ( - M) Ecell = ? (2 decimals accuracy!) 2. Calculate the f.e.m. for the following reaction at 25oC Au3+(aq) (3.0e-2M) +   2I-(aq) (2.2e-3M)      →   Au(s) ( - M) +   I2(s) ( - M) Ecell =? (2 decimals accuracy!)
Using the atomic weights of selected elements given below, find the formula weights for the following...
Using the atomic weights of selected elements given below, find the formula weights for the following compounds:   Atomic weights of selected elements Ca = 40 g moL-1, C = 12 g moL-1, O = 16 g moL-1, H = 1 g moL-1, P = 31 g moL-1, K = 39 g moL-1                   Si = 28 g moL-1, Al = 27 g moL-1, S = 32 g moL-1, N = 14 g moL-1 Example: (NH4)2SO4 Element no. of moles Atomic...
1. Calculate the weighted average cost of capital for a company given the following information: Risk-free...
1. Calculate the weighted average cost of capital for a company given the following information: Risk-free rate in the U.S.: 4% Expected return on the U.S. market portfolio: 14% Company’s risk relative to the market risk: 0.9 The company has 2-year, 12% bonds (paid semi-annually), face value of $1,000, selling for $1095.73. The company’s marginal tax rate: 35% The company finances 38% of its capital by debt and 62% by common equity. 2. Calculate the weighted average cost of capital...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
Moving Averages.  Use the below actual sales to calculate a three-year average which will be used as...
Moving Averages.  Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods (chapter 14, text). Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text). Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text). Month Actual Sales 1 3050 2 2980 3 3670 4 2910 5 3340 6 4060 7 4750 8 5510 9 5280...
how to calculate the balance using the weighted average method on the ledger card
how to calculate the balance using the weighted average method on the ledger card
Using the following information for ABC Bank, calculate the bank’s ratios of Tier 1- capital- to-risk-weighted...
Using the following information for ABC Bank, calculate the bank’s ratios of Tier 1- capital- to-risk-weighted assets and Total-capital- to-risk-weighted assets under Basel II norms. (Rupees in million) Cash 4.5 SLCs backing CPs 17.5 G-Secs 25.6 Long term unused loan commitments to companies 30.5 Deposits with other banks 4.0 Total OBS 48.0 Secured mortgaged loans 50.8 Tier 1 capital 7.5 Loans to pvt companies 105.3 Tier 2 capital 9.5 Total assets 190.2 Ignore market risks & operational risks. Comment on...
Calculate the weighted average cost of capital for a company given the following:        Dividend expected...
Calculate the weighted average cost of capital for a company given the following:        Dividend expected in year one: $1.62/share        Expected dividend growth rate in perpetuity: 3.5%/year        Current market price of company’s common stock: $13.00/share        Company’s debt is in the form of 7-year, 11% (annual) bonds with a face value of $1,000 per bond. Current market value of bonds is $1,058.81/bond        Number of common stocks outstanding: 21,000,000        Market value of debt and equity combined: $420...
Calculate the weighted average cost of capital for a company given the following:       Dividend expected in...
Calculate the weighted average cost of capital for a company given the following:       Dividend expected in year one: $1.62/share       Expected dividend growth rate in perpetuity: 3.5%/year       Current market price of company’s common stock: $13.00/share       Company’s debt is in the form of 7-year, 11% (annual) bonds with a face value of $1,000 per bond. Current market value of bonds is $1,058.81/bond       Number of common stocks outstanding: 21,000,000       Market value of debt and equity combined: $420 million       The company’s marginal tax rate:...
1. Calculate the theoretical yield using your initial volume of 1-butanol used. 2. calculate the percent...
1. Calculate the theoretical yield using your initial volume of 1-butanol used. 2. calculate the percent yield of the product? Mass of sodium bromide (g): 2.00 g Volume of 1-butanol used (mL): 2.0mL Mass of tared vial: 9.01 g Mass of tared vial + product: 9.31 g Mass of product 0.30 g
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT