Question

In: Advanced Math

find the mean using excel 1,2,3,11,22,33

find the mean using excel

1,2,3,11,22,33

Expert Solution

Solution:

Mean Formula =(Sum of Items)/(Number of Items)

Sum of Items

=

1+2+3+11+22+33

=

72

Number of Items

=

1,2,3,11,22,33

=

6

Mean

=

72/6

=

12

Colby Messinger answered 1 year ago

What is Mirr? how do you find it using excel without using excel formula? Below is...

What is Mirr? how do you find it using excel without using excel formula? Below is cash flow. I found IRR is 15.59% and required return is 12% CF Y0 Y1 Y2 Y3 Y4 Y5 Y6 Capital spen $ (30,000,000.00) $ 15,062,400.00 Opp cost $ (5,000,000.00) NWC $ (1,120,000.00) $ (150,000.00) $ (170,000.00) $ 140,000.00 $ 1,300,000.00 OCF $ 9,015,600.00 $ 11,392,500.00 $ 12,193,200.00 $ 10,435,800.00 $ (2,640,000.00) $ (3,960,000.00) CF $ (36,120,000.00) $ 8,865,600.00 $ 11,222,500.00 $ 12,333,200.00 $...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

Use Descriptive Statistics in Excel to find the mean, median, range and standard deviation of the...

Use Descriptive Statistics in Excel to find the mean, median, range and standard deviation of the data below. Table 1: Health Expenditures as a Percentage of GDP of countries around the world 3.35 5.96 10.64 5.24 3.79 5.65 7.66 7.38 5.87 11.15 5.96 4.78 7.75 2.72 9.50 7.69 10.05 11.96 8.18 6.74 5.89 6.20 5.98 8.83 6.78 6.66 9.45 5.41 5.16 8.55

using excel functions Using Table 13.1, (a) find the value of an investment after 4 years...

using excel functions Using Table 13.1, (a) find the value of an investment after 4 years on an ordinary annuity of $5,000 made semiannually at 4%; and (b) recalculate, assuming an annuity due. Wally Beaver won a lottery and will receive a check for $2,500 at the beginning of each 6 months for the next 6 years. If Wally deposits each check into an account that pays 6%, how much will he have at the end of the 6 years?...

Using the data in the Excel file Cell Phone Survey, determine if the mean response for...

Using the data in the Excel file Cell Phone Survey, determine if the mean response for Customer Service rating is different for the carriers (consider only AT&T, Verizon, and Sprint) for significance level of 5%. Gender Carrier Type Usage Signal strength Value for the Dollar Customer Service M AT&T Smart High 5 4 4 M AT&T Smart High 5 4 2 M AT&T Smart Average 4 4 4 M AT&T Smart Very high 2 3 3 M AT&T Smart Very...

I am using Excel to try and solve these problems but can find the answers or...

I am using Excel to try and solve these problems but can find the answers or figure out why my answers are wrong, please help. 1. Today, your roommate purchased an annual perpetuity of $1,000. The payments on his perpetuity will begin in one year. You purchased an annual perpetuity of $1,000. Your payments begin immediately. Assuming a 10% discount rate for these perpetuities, which of the following statements is true? A. Your perpetuity is worth $1,000 more than the...

Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and...

Using Excel to Plot a Histogram This exercise is to be completed using Microsoft Excel and will be turned in on Thursday, September 20th in class. You are to follow the steps we used in class on 9-13-2018 to construct the histogram for the data consisting of the ages of the 50 most powerful women in the world from 2012 (Source: Page 39 of textbook via Forbes Magazine). Your work should have columns for: 1. the raw data; 2. the...

What does it mean when using the z statistic to find population mean with a known...

What does it mean when using the z statistic to find population mean with a known population standard deviation using ?

Z is a random normal variable. Find the following z values using excel: a. What is...

Z is a random normal variable. Find the following z values using excel: a. What is the value of z if the area to the left of z is 0.9515 ? b. What it the value of z if the area to the left of z is 0.1249 ? c. What is the value of z if the area to the right of z is 0.33 ? d. What is the z value such that the area between -z and...

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line. X-Bar 2 4 5 6 Y-Bar 7 11 13 20