Question

In: Statistics and Probability

In excel, list the values of your bill for the last 12 months on one column....

  1. In excel, list the values of your bill for the last 12 months on one column.
  2. Find the sample mean and sample standard deviation of your data.
  3. Pick three bills from the last 12 months and change the values into z-scores. What does the z-score tell you about that particular month?
  4. Between what two values would be considered a normal bill? Remember, being within 2 Standard Deviations is considered normal.
  5. Are any of your bills in the last 12 months unusual? Very unusual?
  6. Are there times when you would accept an "unusual" bill? Explain.

Electric bill-

10/5- 99.80

11/5- 80.80

12/5- 92.80

1/5- 94.00

2/5- 100.48

3/5- 98.40

4/5- 88.78

6/5- 138.88

7/5- 160.88

8/5- 140.38

9/5- 124.20

10/5- 98.56

Solutions

Expert Solution


Related Solutions

In excel, list the values of your bill for the last 12 months on one column....
In excel, list the values of your bill for the last 12 months on one column. Find the sample mean and sample standard deviation of your data. Pick three bills from the last 12 months and change the values into z-scores. What does the z-score tell you about that particular month? Analysis Between what two values would be considered a normal bill? Remember, being within 2 Standard Deviations is considered normal. Are any of your bills in the last 12...
Log onto website where you can observe your service bill for the last 12 months (electric...
Log onto website where you can observe your service bill for the last 12 months (electric bill, cell phone bill, water bill, etc.). If you do NOT feel comfortable sharing this data, you can make up values. In excel, list the values of your bill for the last 12 months on one column. Find the sample mean and sample standard deviation of your data. Pick three bills from the last 12 months and change the values into z-scores. What does...
Log onto website where you can observe your service bill for the last 12 months (electric...
Log onto website where you can observe your service bill for the last 12 months (electric bill, cell phone bill, water bill, etc.). If you do NOT feel comfortable sharing this data, you can make up values. In excel, list the values of your bill for the last 12 months on one column. Find the sample mean and sample standard deviation of your data. Pick three bills from the last 12 months and change the values into z-scores. What does...
Excel sorting In excel how do you sort a column of months in ascending order and...
Excel sorting In excel how do you sort a column of months in ascending order and not alphabetical when the month is in word format?
Locate two current (within the last 12 months) advertisements -- one that you consider to be...
Locate two current (within the last 12 months) advertisements -- one that you consider to be "the worst" and one that you consider to be "the best." (Each must be from different media types, both must be from American media, and actual source documentation must be provided for where and when the ads ran.)  Note: ads that ONLY appear on YOUTUBE can not be used. Prepare a two page typed critique discussing why you find one ad bad and the other...
Use Excel to generate a column of x values from 0 to 2.5 in steps of...
Use Excel to generate a column of x values from 0 to 2.5 in steps of 0.05 (that means your column must have numbers like 0, 0.05, 0.1, 0.15, . . . , 2.5). Plot the PDF f(x) on your computer screen for the different values of x mentioned above for the following distributions. (a) Uniform (use A = 0 and B = 2.5) (b) Exponential (use mean = 2) (c) Gamma (use parameters 1.7 and 1.2) (d) Normal (use...
please list a current (within the last 12 months) business incident—found via the news media-- describing...
please list a current (within the last 12 months) business incident—found via the news media-- describing its ethics parameters.
1.Think of three stressors you have experienced in the last 12 months. Identify your stressors as...
1.Think of three stressors you have experienced in the last 12 months. Identify your stressors as daily, acute, chronic or catastrophic 2. Imagine you are a newly hired Health and Safety Coordinator in charge of conducting a Health and Safety Audit to prevent the spread of COVID 19. What controls would you implement to prevent contact with the Biohazard COVID 19 in your workplace? Type of ControL Description Examples Engineering Administrative Personal Protective Equipment Personal Hygiene
Consider all observations as one sample of X (1st column) and Y (Second column) values. Answer...
Consider all observations as one sample of X (1st column) and Y (Second column) values. Answer the following questions: 78 4.4 74 3.9 68 4 76 4 80 3.5 84 4.1 50 2.3 93 4.7 55 1.7 76 4.9 58 1.7 74 4.6 75 3.4 80 4.3 56 1.7 80 3.9 69 3.7 57 3.1 90 4 42 1.8 91 4.1 51 1.8 a) Calculate the correlation coefficient r b) Fit the regression model (prediting Y from X) and report...
3. There is one 1$ bill and one 5$ bill in your left pocket and the...
3. There is one 1$ bill and one 5$ bill in your left pocket and the same in your right pocket. You move one bill from the left pocket to the right pocket. After that you take the remaining bill from the left pocket and one of the bills at random from the right pocket. Let ? denote the amount of money that you take from the left pocket and ? denote the amount of money that you take from...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT