Question: I need to make this Excel file. Instructions: Complete the following tasks in Excel and upload it to quiz. Binomial distribution Do you believe your
I need to make this Excel file.


Instructions: Complete the following tasks in Excel and upload it to quiz. Binomial distribution "Do you believe your children will have a higher standard of living than you have?" This question was asked of a national sample of American adults with children in a Time/CM poll (Jan. 29, 1996). Sixty-three percent answered yes. Suppose that asking adults whether or not their children will be better off is a binomial experiment. i. At the top of your Excel sheet, construct and complete the following table: Number of trials (n) Probability of Success (1) ii. Suppose x is a random variable denoting 'the number in a random sample of 5 American adults who believe their children will have a higher standard of living'. In a column (titled *), list all possible values of x. iii. Use Excel's binomial distribution function to compute the probability for each value of x. List those probabilities in the next column and title it f (x). iv. Use the next column, titled x f (x), to compute the expected value of x. Ensure to put the sum below the last value in that column. Bold it. v. Use the next column, titled (x - #) f(x), to compute the variance of x. Ensure to put the sum below the last value in the column. Bold it. vi. At the bottom of your Excel sheet, construct and complete the following table: E(x) =nXx Var(x) = nxx x (1-1)Normal distribution The United States Environmental Protection Agency calculates an Air Quality Index (AQI) that tracks the daily air quality. The AQI is measured on a scale ranging from 0 to 500, which indicates the extent to which your air is clean/polluted, and the potential health effects thereof. The AQI is typically divided into six categories as displayed in table 1. Table 1 Level of health concern Air quality index Good 0 to
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
