3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from 0 to 15 for the following three distributions: a. Hypergeometric, where n = 9, N = 50, D = 20 b. Binomial, where n = 75 and p = 0.1 c. Poisson, where np = 6 4. [23 points] Visual data displays and assessing normality a. [2 points] Using Excel or Minitab, generate 100 data points that follow a normal distribution with mean equal to 450 and standard deviation equal to 25. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "-NORMINV(RAND(), 450, 25)" ii. In Minitab, you click on "Calc > Random Data > Normal: You should ask for 100 rows of data in a column with mean equal to 450 and standard deviation equal to 25. b. [2 points] Using Excel or Minitab, generate 100 data points that follow a uniform distribution. Set the upper and lower limits to 525 and 375 respectively. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "=375+ (150*RAND())" where range is the upper limit - lower limit ii. In Minitab, you click on "Calc > Random Data > Uniform: generate 100 rows of data in a column. You input the above designated lower and upper limits. c. [15 points] Use the Stem-and-Leaf Plot, Histogram, and Box Plot functions in Minitab to assess both the normal and uniform data sets. Include the graphs with your response. d. [4 points] Use the Normal Probability Plot function in Minitab - click "Graph > Probability Plot > Single to evaluate normality for both the normal and uniform data sets. Include both graphs with your response. 3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from 0 to 15 for the following three distributions: a. Hypergeometric, where n = 9, N = 50, D = 20 b. Binomial, where n = 75 and p = 0.1 c. Poisson, where np = 6 4. [23 points] Visual data displays and assessing normality a. [2 points] Using Excel or Minitab, generate 100 data points that follow a normal distribution with mean equal to 450 and standard deviation equal to 25. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "-NORMINV(RAND(), 450, 25)" ii. In Minitab, you click on "Calc > Random Data > Normal: You should ask for 100 rows of data in a column with mean equal to 450 and standard deviation equal to 25. b. [2 points] Using Excel or Minitab, generate 100 data points that follow a uniform distribution. Set the upper and lower limits to 525 and 375 respectively. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "=375+ (150*RAND())" where range is the upper limit - lower limit ii. In Minitab, you click on "Calc > Random Data > Uniform: generate 100 rows of data in a column. You input the above designated lower and upper limits. c. [15 points] Use the Stem-and-Leaf Plot, Histogram, and Box Plot functions in Minitab to assess both the normal and uniform data sets. Include the graphs with your response. d. [4 points] Use the Normal Probability Plot function in Minitab - click "Graph > Probability Plot > Single to evaluate normality for both the normal and uniform data sets. Include both graphs with your response.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
I need your to make a decision. I am considering making a long term investment on a project. My initial investment would be $18,250 but the after tax cash inflows it should deliver back to my company...
-
The Chronicle of Higher Education (January 29, 2003) summarized an article that appeared on the American Prospect web site titled College Try: Why Universities Should Stop Encouraging Applicants to...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Which sensing structure helps a company test and make sense of new ideas generated through other types of sensing? Social listening Crowdsourcing Blue ocean Pilot test
-
Find the slope of the tangent line to the graph of r = 3 + 3 cos at the point on the graph where = 1/6 .
-
Exercise 10-21A (Algo) Effective interest amortization of a bond premium LO 10-7 On January 1, Year 1, Young Company issued bonds with a face value of $132,000, a stated rate of interest of 16...
-
Assuming that the mixture is ideal, estimate infinite dilution Fickian diffusivities at 283.3 \(\mathrm{K}\) for chlorobenzene in liquid bromobenzene and for bromobenzene in liquid chlorobenzene from...
-
The following quotation is from an address made by an officer of the British Motor Company: We can all, I think, take pride in the way cost accounting has kept pace with business development in this...
-
Required information [The following information applies to the questions displayed below.] Lansing Company's current-year income statement and selected balance sheet data at December 31 of the...
-
Refer to the North Valley Real Estate data, which report information on homes sold during the last year. For the variable price, select an appropriate class interval and organize the selling prices...
-
A 1 7 0 . 0 g sample of lead ( clead = 1 . 3 x 1 0 2 J / kg - oC ) is heated to 1 2 0 . oC and then plunged into 2 0 0 . 0 mL of water at 1 0 . 0 oC . What will be the final temperature of the...
-
2. How many blocks are needed for the 10th staircase? 2 3
-
Identify at least two plausible service departments in your industry* (not including HR, IT or maintenance). Describe the departments, the services they provide to the producing departments or to...
-
In January, Tongo, Incorporated, a branding consultant, had the following transactions. Indicate the accounts, amounts, and direction of the effects on the accounting equation under the accrual...
-
1. Define Operational and Business risk. 2. How does operational and business risklead to bank failures? 3. Provide some general background on the history of Guaranty Bank. What led to the bank's...
-
Swift Skateboards sells unassembled skateboards for $65 each. Variable production costs for each board are $10 and fixed production costs are $18. Swift is considering selling the skateboards fully...
-
Suppose you buy a sleek Italian racing automobile (e.g. Fiat) and you have the choice of paying the full price, $41,000, now; or $10,000 at the end of each of the next five years. What is the cost of...
-
A woman at a point A on the shore of a circular lake with radius 2 mi wants to arrive at the point C diametrically opposite on the other side of the lake in the shortest possible A time. She can walk...
-
The fundamental frequencies of two air columns are the same. Column A is open at both ends, while column B is open at only one end. The length of column A is 0.70 m. What is the length of column B?
-
The isotope 198 79 Au (atomic mass = 197.968 u) of gold has a half-life of 2.69 days and is used in cancer therapy. What mass (in grams) of this isotope is required to produce an activity of 315 Ci?
-
A helicopter has two blades (see Figure 8.11); each blade has a mass of 240 kg and can be approximated as a thin rod of length 6.7 m. The blades are rotating at an angular speed of 44 rad/s. (a) What...
-
Most experts maintain that the computer frauds that are publicly revealed represent only the tip of the iceberg. Although the major threat to computer security is perceived by many to be external,...
-
An experienced senior auditor was assigned to investigate a possible fraudulent situation characterized by extremely high, unexplained merchandise shortages at one location of the companys department...
-
A small but growing firm has recently hired you to investigate a potential fraud. The company heard through its hot line that the purchases journal clerk periodically enters fictitious acquisitions....
Study smarter with the SolutionInn App