[Step-by-Step] Robert Pencil Warren 1 , you will remember him from the midterm, has been asked by the Prescott Rural Electric Coop to study the costs of
Question: Robert Pencil Warren 1 , you will remember him from the midterm, has been asked by the Prescott Rural Electric Coop to study the costs of several households in a subdivision, Prescottvilla that they serve. The folks there are concerned that their bills are " Too darn high ." Here are the costs for a recent month at the homes in Prescottvilla along with the number of rooms that each home has.
| Customer Number | Amount of Electric Bill | Number of Rooms |
| PV - #002345 | $118.20 | 5 |
| PV - #002346 | $76.90 | 6 |
| PV - #002347 | $67.88 | 5 |
| PV - #002348 | $144.56 | 7 |
| PV - #002349 | $133.40 | 7 |
| PV - #002350 | $127.89 | 6 |
| PV - #002351 | $88.42 | 6 |
| PV - #002352 | $89.34 | 7 |
| PV - #002353 | $110.34 | 8 |
| PV - #002354 | $129.10 | 8 |
| PV - #002355 | $134.56 | 8 |
| PV - #002356 | $99.54 | 6 |
Compute range, standard deviation, quartiles, and anything else you can think about and then discuss what old Robert should tell the Coop about the bills in Prescottvilla . Are the bills too high, given what you know about the data?
If the average customer for the Coop has a monthly bill of $124.56 and has seven ( 7 ) rooms, are the people in Prescottvilla paying too much, just about right or too little for their electric service?
Deliverable: Word Document 