Use Excel to find the five-number summary for the Presidential Height Data.  On your worksheet, click on any cell in a new column.  Click the Insert Function fx button in the Formula Bar.  In the Insert Function dialog box, select the category Statistical from the dropdown bar.  In the Select a Function box, click QUARTILE.INC and click Ok.  In the Array box, enter the range of data values.  In the Quart box, enter 0 to find the minimum, 1 to find the 1st quartile, and similarly enter 2, 3, 4 for the other values. Clearly label each of the five numbers.

The dotplot shows the distribution of passing rates for the bar exam at 185 law schools in the United States in a certain year. The five number summary is 28, 78, 86, 91.5, 99. Draw the boxplot and explain how you determined where the whiskers go. Click the icon to view a dotplot of bar exam passing rates. Draw the boxplot. Select the correct answer below. ○ A. 100 Bar-Pass Rate (%) ○ B. Q ✓ 0 100 Bar-Pass Rate (%) ○ C. ○ D. Q Q --- 0 Bar-Pass Rate (%) 100 G 0 100 Bar-Pass Rate (%) Explain how you determined where the whiskers go. Select the correct answer below and fill in the answer boxes to complete your choice. (Type integers or decimals. Do not round.) OA. The whiskers extend to the most extreme values that are not potential outliers. The left whisker extends to the smallest observation that is greater than or equal to extends to the largest observation that is less than or equal to OB. The whiskers extend to the minimum, OC. The whiskers extend to the left outlier, and the…

General Social Survey (GSS) 2006 collected the data of the number of people in each household in the U.S. The variable name is "hompop."

Please solve with the full step and no reject thank u

Use excel to do all calculations. Please show all work.

You land a job at an online marketing/consulting firm after attaining a business degree with an emphasis in statistics. You walk into your office on the first day and there is an assignment sitting upon your desk. The firm was recently hired by ImpulseBuy Now.com (a famous online clearing house for as-seen-on-TV junk items). ImpulseBuyNow wanted to know if the amount of time spent browsing by a customer at their online site associates to how many items the customer purchased. Sound familiar? Realizing that you listed a statistical emphasis in your business degree, you panic and pull out your old statistics notes as to find this unit in the study guide. What luck! You must figure out what to tell ImpulseBuy Now about their question. Here is the data provided by ImpulseBuy Now: Browse Time (min.) 0-10 11-20 More than 20 Browse Time (min.) 0-10 Items Purchased Zero 1000 And your final p-value is extremely small. 1500 500 One 900 Expected Values Zero 600 2600 2500 Your paycheck depends…

Describe about Multiple Comparisons.

find population sd   12,15,18,16,19,22,23,25,28

The boxplots show data for state and local community expenditures on hospitals and highways. Hospitals Estimate Q1, Q2, and Q3 for hospital and highway spending. Highways Billions of Dollars

Widget Sales Jesaki Inc. is trying to enter the widget market. The research department established the following price-demand, cost, and revenue functions: p(x) = 60 1.20x Price- demand function Cost function C(x) = 210 + 12x R(x) = xp(x) = x(60 - 1.20x) where x is in thousands of widgets and C(x) and R(x) are in thousands of dollars. The price p(x) is the price in dollars of one widget when the demand is a thousand widgets. All three functions have domain 1 ≤ x ≤ 50. Revenue function