Question

In: Math

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

Solutions

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


Related Solutions

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
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?
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT