Question

This is stat question and the data show as below This is stat question and the data show as below Flows in the Credit River in Mississauga are given in the file credit.MPJ or in the file credit.xlsx. C1 C2 Feb C3 C4 C5 April Lu 36 260 95 72 327 184 154 58 178 205 335 101 62 294 250 92 87 64 87 224 69 129 95 238 127 163 239 124 17 18 19 20 21 61 30 40 19 13 23 21 59 104 47 23 24 25 26 27 28 29 30 31 32 37 105 38 59 100 32 18 31 39 26 19 27 38 26 42 87 34 35 36 37 38 39 40 121 65 49 85 69 36 50 37 59 48 42 48 36 48 43 45 46

thin one standard deviation or the mean 「er mich of the months, does it agre approximately ith the value trom the empirical rule of 66% 1 「or each of the three months April February and AuO st calculate the num be of observations that lie April August Februry

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Let's enter data in excel and do the calculations:

D40 27 38 26 34 49 68 48 34 48 36 48 24 23 121 65 64 87 224 69 129 95 238 127 163 239 124 19 20 21 23 85 69 36 50 37 59 24 25 26 27 28 29 30 155.3214 57.25 34.42857 Averages of each columns 31 85.46764 26.87222 14.9366 Population standard deviations of each columns 32 69.85378 30.37778 19.49197 Liower 1 sigma limits 33 240.7891 84.12222 49.36517 Upper 1 sigma limits 34 35 64.28571 60.71429 36 37 Since 75% is greater than 66% so correct choice is Aug. 21 Total number of observations lies between lower and upper limits 75 Total % of the data lies between Lower and Upper limits. 18 17 38

The formulae used on the above excel-sheet are as follows:

19 64 20 87 21 224 22 69 23 129 24 95 25 238 26 127 27 163 28 239 29 124 30 FAVERAGE(A2:A29) FAVERAGE(B2:B29) FAVERAGE(C2:C29) Averages of each col 31 STDEV.P(A2:A29) STDEV.P(B2:B29) STDEV.P(C2:C29) Population standard 32 EA30-A31 33 EA30+A31 34 18 35 (18/28)*100 36 37 Since 75% is greater i 38 24 23 121 65 85 69 36 50 37 59 27 38 26 34 49 68 48 34 48 36 48 B30-B31 B30+B31 17 (1700/28) -C30-C31 -C30+C31 21 -2100/28 Liower 1 sigma limits Upper 1 sigma limits Total number of obs Total % of the data li

Add a comment
Know the answer?
Add Answer to:
This is stat question and the data show as below This is stat question and the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • These are my instructions: Your data should have been read in from the data file and stored into ...

    These are my instructions: Your data should have been read in from the data file and stored into an array. Next you need to calculate the following and display in a single Message box: Average score Highest score Lowest score Mode of the scores Your program should be written using methods and should be well documented internally and externally. Your output should be displayed using Message boxes. This is the .text file to use with the instructions: 20 21 22...

  • Sample Data Sample Data Hour Sample Taken Hour Sample Taken 1 4 5 X 1 3...

    Sample Data Sample Data Hour Sample Taken Hour Sample Taken 1 4 5 X 1 3 1 42 2 3 4 5 6 2 39 36 25 60 28 53 22 56 41 34 43 45 59 42 36 40 45 39 48 26 42 34 61 48 45 29 3 31 61 38 40 54 26 38 42 37 41 53 37 47 41 37 29 20 26 43 38 33 37 37 35 33 36 41 25 37...

  • Please show how you did this in excel. :13-19 Every home football game for the past...

    Please show how you did this in excel. :13-19 Every home football game for the past eight years at Eastern State University has been sold out. The revenues from ticket sales are significant, but the sale of food, beverages, and souvenirs has contrib- uted greatly to the overall profitability of the football program. One particular souvenir is the football pro- gram for each game. The number of programs sold at each game is described by the following probabil- ity distribution:...

  • I literally have no idea what I’m doing. Help!!! Please show work!! Write an essay using...

    I literally have no idea what I’m doing. Help!!! Please show work!! Write an essay using Word and post it as an attachment to the discussion. Cover the following points. Choose a data set from Stat Disk using one of the following files from 13th Edition Elementary Statistics: Oscar Winner Freshman 15 Word Count Garbage Weights Passive and Active Smoke If the file contains more than one variable, choose a quantitative variable. Create a histogram using your chosen variable and...

  • Suppose a binary tree data (in tiny written size) is stored in an array (A) as...

    Suppose a binary tree data (in tiny written size) is stored in an array (A) as given below and root is placed at “0”index. Note the array indices are in larger written size (0 to 74). Show the traversal data of the given tree for a)      In-Order Traversal b)     Post Order Traversal A 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 3 28 13 36 15 9 22 44 7 10 75 33 19 15...

  • This is stat question and the data show as below This is stat question and the...

    This is stat question and the data show as below This is stat question and the data show as below Flows in the Credit River in Mississauga are given in the file 'credit.MP]' or in the file 'credit.xlsx. 29331 2 1 3321 23234 8 6 4 3 3 2 4 25274431 5 5 863535 2 2 8-7 2 3 2 3 2 9 6 4 3 2 31 - 2 78901 2345678901 23456789 11122222222223333333333 2 February and August calculate the...

  • can someone take a look to these 3 pictures and fill in the blanks. I need...

    can someone take a look to these 3 pictures and fill in the blanks. I need to show work and understand the answers. thank you! Birth to 36 months: Girls Head circumference-for-age and Welght-for-length percentiles NAME RECORD # Birth 3 69 12 15 18 21 24 27 30 33 36 AGE (MONTHS cm in ina cm 52 19--48 46 46-18 42 50 22 48 15--38 2044 19--42 18-40 38 36 34 -32 13 16 13 28 E 11 24 H...

  • 48 57 Amy Bakery has four shops in different area in a city. Monthly sales (in...

    48 57 Amy Bakery has four shops in different area in a city. Monthly sales (in thousands of dollars) from a random of 24 months from each of the 4 shops given in Table 1. Table 1: Monthly sales (in thousands of dollars) North East South West 77 75 97 60 45 42 60 54 56 49 68 47 44 39 58 57 63 61 69 51 75 63 79 50 90 81 99 73 32 47 46 41 41...

  • NUMBER OF PEOPLE 10.2 10.0 10.1 8.5 10.2 8.2 8 Source: United States Census. 11. In...

    NUMBER OF PEOPLE 10.2 10.0 10.1 8.5 10.2 8.2 8 Source: United States Census. 11. In the Sanitary District of Chicago, operating engineers are hired on of a competitive civil-service examination. In 1966, there were 223 appl for 15 jobs. The exam was held on March 12; the test scores are s arranged in increasing order. The height of each bar in the histogram next page) shows the number of people with the correspondin examiners were charged with rigging the...

  • Write a python nested for loop that prints out the following pattern 100 99 98 97...

    Write a python nested for loop that prints out the following pattern 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT