opy the table to Excel then for each part using Excel formula to do the questions...

opy the table to Excel then for each part using Excel formula to do the questions below and make sure to apply DCOVA, which stands for Define, Collect, Organize, Visualize, and Analyze.

1. Find the mean and standard deviation,

2. What did you observe and what that means in term of Cholesterol levels for a patient.

3. Find the five-number summary ( Minimum, Q1, Q2, Q3, and Maximum)

4. Interpret your result in term of cholesterol level

5. Find interquartile range (IQR) and what that means?

6. Draw a box-and-whiskers plot for data given

7. Do you have any outliers? Explain the method used to identify the outliers

		Table : Cholesterol Levels:
270	236	210	142	280	272	160
220	226	242	186	266	206	318
294	282	234	224	276	282	360
310	280	278	288	288	244	236

Expert Solution

you can plot box plot using minitab also by entering data into worksheet and goto option graph then choose box plot.

And outlier test using minitab also goto stat option then basic statistics then choose outlier test from the list

milcah answered 1 year ago

Copy the table to Excel then for each part using Excel formula to do the questions...

Copy the table to Excel then for each part using Excel formula to do the questions below and make sure to apply DCOVA, which stands for Define, Collect, Organize, Visualize, and Analyze. 1. Find the mean and standard deviation, 2. What did you observe and what that means in term of Cholesterol levels for a patient. 3. Find the five-number summary ( Minimum, Q1, Q2, Q3, and Maximum) 4. Interpret your result in term of cholesterol level 5. Find interquartile...

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 formula OR Excel function. For questions 1 - 4 use a required nominal annual return:...

using formula OR Excel function. For questions 1 - 4 use a required nominal annual return: 5.00% 1. Consider a 1-year CD. Principal value $5,000.00 What is the future value of the CD in 1 year AND what is the effective annual rate? Future Value EFF a. annual compounding? b. semi-annual compounding? c. quarterly compounding? d. monthly compounding? e. daily compounding? 2. Rework problem #1 assuming a 5-year CD with $5000 principal. Future Value EFF a. annual compounding? b. semi-annual...

Please use ONLY one Excel file to answer the below questions. ( including the formula using...

Please use ONLY one Excel file to answer the below questions. ( including the formula using for Excel) In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. In April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked to select the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chose gold as the best long-term investment. By contrast, only 91 chose bonds. Compute the...

How do you sort every 20th customer from excel into a new table. Formula please

Solve the following questions by using Excel formula. Show me your data 1- If you deposit...

Solve the following questions by using Excel formula. Show me your data 1- If you deposit $20,000 in a bank account that pays 15% interest annually, how much will be in your account after 6 years? 2- If you are planning to invest your money today in a secuirty that pay you $5,000,000 in 15 years with rate of return on your investment of 10% annually. How much you should invest? 3- What's the future value of 7%, 7-year ordinary...

How do you calculate Payback Period on Excel by using FAME function? What is the formula?

please use excel to do it. it also need to come with formula. formula is very...

please use excel to do it. it also need to come with formula. formula is very important. many many thanks. Prepare a sales budget for January through March and for the Quarter in total. The selling price per unit is $50.00. December of the previous year 20,000 January 100,000 February 80,000 March 60,000 April 40,000 2. Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume...

Use the Excel output in the below table to do (1) through (6) for each ofβ0,...

Use the Excel output in the below table to do (1) through (6) for each ofβ0, β1, β2, and β3. y = β0 + β1x1 + β2x2 + β3x3 + ε df = n – (k + 1) = 16 – (3 + 1) = 12 Excel output for the hospital labor needs case (sample size: n = 16) Coefficients Standard Error t Stat p-value Lower 95% Upper 95% Intercept 1946.8020 504.1819 3.8613 0.0023 848.2840 3045.3201 XRay (x1) 0.0386...

USING EXCEL For the most part, our multiple-choice quiz (and Evaluation) questions have four possible...

USING EXCEL For the most part, our multiple-choice quiz (and Evaluation) questions have four possible answers. (Yes, I know. I throw in an extra answer now and then!) Suppose you come to a quiz hoping to guess your way through to a decent grade. Find the probability of guessing at least 5 out of the 10 multiple-choice questions correctly, using BINOM.DIST with pdf (i.e., summing each of the individual probabilities of 5, 6, ….., 9, 10), and then with...

Question