Question

In: Math

Type of Expense                                        

Type of Expense                                                               Cost

Clothing

370.00

Credit card payments

730.00

Mortgage payment

1,920.00

Student loan payments

811.00

Vacation expenses

987.00

Car repair payment

193.00

Groceries

224.00

Use the table above to answer the following questions. Show ALL of your work for full credit.

1. Calculate the mean, median, and mode cost of last month’s expenses.

2. Calculate the range and interquartile range (IQR) of last month’s expenses.

Remember, to find the IQR:

Step 1: Put the numbers in order.

Step 2: Find the median.

Step 3: Place parentheses around the numbers above and below the median.
Step 4: Find Q1 and Q3

Step 5: Subtract Q1 from Q3 to find the interquartile range.

3. Which of the expenses (if any) in the table above is an outlier? Why?

Remember, an outlier is defined as being any point of data that lies over 1.5 IQRs below the first quartile (Q1) or above the third quartile (Q3) in a data set.

High = (Q3) + 1.5 IQR

Low = (Q1) – 1.5 IQR

4. Find the variance and standard deviation. How many standard deviations is the cost of the mortgage payment from the mean cost of all expenses.

5. Explain the difference between the mean and the median. Also, indicate whether the data is skewed or not. Why?

I need help finding number 3 and 4! I believe the range is 1727 and the IQR is 441, but what is the outliers, variance and standard deviation?

Solutions

Expert Solution

Type of Expense Cost
Clothing 370
Credit card payments 730
Mortgage payment 1,920
Student loan payments 811
Vacation expenses 987
Car repair payment 193
Groceries 224
Total 5235
Mean 747.86

1) Total Expenses =5235

Number of types of Expenses = 7

Therefore, Mean =Total Expenses/Number of types of Expenses

= 5235/7

=747.86

For finding Median, first arrange the data in ascending or descending order as

Cost
193
224
370
730
811
987
1,920

Here number of observation is 7 which is odd.

Median will be in (7+1)/2 term i.e.,4th term

Therefore, Median = 730

To find the mode, or modal value, it is best to put the numbers in order. Then count how many of each number. A number that appears most often is the mode.

Here ,for the given data, there is no number which appear the most.

Therefore there is no Mode for the give data.

2) Range = Maximum value of the observation - Minimum value of the observation

= 1920 - 193

= 1727

Steps for finding Interquartile range

  • Step 1: Put the numbers in order.
    193 , 224 , 370 , 730 , 811 , 987 , 1920.
  • Step 2: Find the median.
    193 , 224 , 370 , 730 , 811 , 987 , 1920.
  • Step 3: Place parentheses around the numbers above and below the median.
    Not necessary statistically, but it makes Q1 and Q3 easier to spot.
    (193 , 224 , 370) , 730 , (811 , 987 , 1920).
  • Step 4: Find Q1 and Q3
    Think of Q1 as a median in the lower half of the data and think of Q3 as a median for the upper half of data.
    (193 , 224 , 370) , 730 , ( 811 , 987 , 1920).. Q1 = 224 and Q3 = 987.
  • Step 5: Subtract Q1 from Q3 to find the interquartile range.
    987 - 224 = 763

Therefore Interquartile range =763

3) Here, Q1=224

Q3= 987

IQR=763

So, high = Q3 +1.5 IQR =987 + (1.5*763) = 2131.5

low= Q1 - 1.5 IQR =224 -(1.5*763) = -920.5

An outlier is defined as being any point of data that lies over 1.5 IQRs below the first quartile (Q1) or above the third quartile (Q3) in a data set.

We have to check whether the data is outside the Range (-920.5 , 2131.5)

There is no data which is outside the given range. So, there is no Outlier in the given data.

4)

Type of Expense Cost X- mean (x-mean)^2
Clothing 370 -377.86 142778.18
Credit card payments 730 -17.86 318.98
Mortgage payment 1,920 1172.14 1373912.18
Student loan payments 811 63.14 3986.66
Vacation expenses 987 239.14 57187.94
Car repair payment 193 -554.86 307869.62
Groceries 224 -523.86 274429.30
Total 5235 2160482.86
Mean 747.86

Variance =

=

= 308640.41

Standard Deviation =

Variance of the cost of the mortgage payment from the mean cost of all expenses =

   =

   =196273.17

Therefore Standard Deviation of the cost of the mortgage payment from the mean cost of all expenses

=


Related Solutions

Suggest one (1) consequence of improperly classifying an account type (e.g., if an expense is classified...
Suggest one (1) consequence of improperly classifying an account type (e.g., if an expense is classified as an asset or an asset is classified as an expense). Describe the effect on at least two (2) of the four (4) major financial statements: Profit & Loss (Income) Statement, Statement of Retained Earnings, Balance Sheet, and Statement of Cash Flow.
For which type(s) of retirement plans is the yearly pension expense affected by expected market value...
For which type(s) of retirement plans is the yearly pension expense affected by expected market value changes of the assets of the plan? Select one: a. Both Defined Benefit and Defined Contribution b. Neither Defined Benefit nor Defined Contribution c. Defined Benefit, but not Defined Contribution d. Defined Contribution, but not Defined Benefit
A company should adjust pension expense for which type of revenue(s) accumulated in the pension fund?...
A company should adjust pension expense for which type of revenue(s) accumulated in the pension fund? Select one: a. Interest Revenue, but not Dividend Revenue b. Dividend Revenue, but not Interest Revenue c. Both Dividend Revenue and Interest Revenue d. Neither Dividend Revenue nor Interest Revenue
(3 marks) Kimmel Corp. uses the expense approach (assurance type) to account for warranties. They sell...
Kimmel Corp. uses the expense approach (assurance type) to account for warranties. They sell a used car for $30,000 on Oct 25, Year 6, with a one-year warranty covering parts and labour. Warranty expense is estimated at 2% of the selling price, and the appropriate adjusting entry is recorded on Dec 31, Year 6. On March 12, Year 7, the car is returned for warranty repairs. This cost Kimmel $320 (you can assume a cash credit). Provide the journal entry...
Fund Name Fund Type Net Asset Value ($) 5 Year Average Return (%) Expense Ratio (%)...
Fund Name Fund Type Net Asset Value ($) 5 Year Average Return (%) Expense Ratio (%) Morningstar Rank Amer Cent Inc & Growth Inv DE 28.88 12.39 0.67 2-Star American Century Intl. Disc IE 14.37 30.53 1.41 3-Star American Century Tax-Free Bond FI 10.73 3.34 0.49 4-Star American Century Ultra DE 24.94 10.88 0.99 3-Star Ariel DE 46.39 11.32 1.03 2-Star Artisan Intl Val IE 25.52 24.95 1.23 3-Star Artisan Small Cap DE 16.92 15.67 1.18 3-Star Baron Asset DE...
Question 20 2.5 pts Merchandise Inventory is what type of account? Liability Expense Asset Contra-Asset Flag...
Question 20 2.5 pts Merchandise Inventory is what type of account? Liability Expense Asset Contra-Asset Flag this Question Question 21 2.5 pts Returned merchandise for credit on account. The perpetual inventory system is in use. This will be recorded with: a debit to an asset and a credit to a liability. a debit to an asset and a credit to an expense. a debit to a liability and a credit to an expense. a debit to a liability and a...
we learned about interest expense on notes payable. Interest expense is an actual expense. we learned...
we learned about interest expense on notes payable. Interest expense is an actual expense. we learned about bad debt expense.  Bad debt expense is an estimated expense. 1. What is the difference between an actual expense and an estimated expense? 2. Why do we have to record bad debt expense, which is an estimated expense?
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value Strip shopping center $800,000 $448,000 $136,016 $7,692 $912,000 Small apartment complex $650,000 $292,500 $91,281 $8,273 $685,100 The first potential investment consists of a seven-store shopping center, which has a current market price of $800,000. Of this amount, $200,000 represents the cost of the land, and the balance, $600,000, is attributable to buildings on the property. The second possible investment, which costs $650,000, consists of...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value...
Property type Price Mortgage Expected Estimated Rental income Depreciation expense resale (per year) (per year) value Strip shopping center $800,000 $448,000 $136,016 $7,692 $912,000 Small apartment complex $650,000 $292,500 $91,281 $8,273 $685,100 The first potential investment consists of a seven-store shopping center, which has a current market price of $800,000. Of this amount, $200,000 represents the cost of the land, and the balance, $600,000, is attributable to buildings on the property. The second possible investment, which costs $650,000, consists of...
is staff training an expense or asset? is delivery fee an expense or asset? is vehicle...
is staff training an expense or asset? is delivery fee an expense or asset? is vehicle hire an expense or asset?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT