Question

and a b. Construct a cumultive erente ovon Choose the comect cumulative encentae ooom b
ос. Cost of Electricity 195 107 159 199 176 152 98 152 199 144 841 150 190 85 125 164 110, 155 206 126 170 141 151 207 172 126 127 140 163 114 167 91 151 113 156 207 85 172 135 13 152 11140 113 121 141 190 91 156 154 157 135 140 185 173 142151 137 185 163126 84 Print Done 0200 75 115 155 195 Cos: of Elestidsy centage opolvaon below
I Cik the kon to vew the dala table Choose the corect cmulative percentage polygon below Ов. O C. c. Around what amount does the OA. The m ofutity charges are dustered betwem S170 and S220 OB. The majoty atutky charges are distered between S100 and $130 O C. The majority of utlity charges are clustered betreen $150 and $220 O D. The majority of utility charges are clustered beeen $110 and 5180
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer to the question)

enter the data in excel

sort the data

set the bin values in another column as follows:

Bin values 91 98 107 110 95 113 114 118 135 145 155 165 175 185 126 126 127 127 135 137 5

.

Now click on data tab

Click on data analysis

In it select histogram

following window appears on screen;

Bin values Histogram 91 SA$1:$A$50 $C$3:$C$16 Input Range 95 105 115 Cancel 107 Bin Range: 110 Help Labels Output options O Qutput Range: O New Worksheet Ply: O New Workbook 113 114 118 135 145 165 175 126 126 127 127 135 Pareto (sorted histogram) Cutie ercentage Chart Output 195 215

.

Enter the input range

enter the bin range

tick mark the check box of "chart output"

then click Ok

The following histogram appears on the screen

1 Bin Frequenc Histogram 95 105 115 135 145 -Frequency 10 165 175 3 Bin 13 14 195 215 16 More

.thus for part a, chart B is the correct answer.

.

Part b)

In cumulative percent the line goes form lower left to upper right , hence again chart b is the correct answer for it

Part c)

the maximum values are concentrated in the center of the graph between 110 to 180

Hence the last answer choice is correct

STZ 3 S6T ba SST SET 86420 h3uon bay 211525696432220 85 95 105 15 1 4 123456789

Add a comment
Know the answer?
Add Answer to:
and a b. Construct a cumultive erente ovon Choose the comect cumulative encentae ooom b ос....
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
  • Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your...

    Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your pre-pregnancy weight six months after giving birth. Public health officials are interested in whether this is a realistic goal. Do the women in North Carolina weigh more than their pre-pregnancy weight six months postpartum? In other words, is the six months post-pregnancy weight greater than their pre-pregnancy weight? Use a paired samples t-test to compare pst6wght (variable 1) and prewght (variable 2). This uses...

  • Population 1 Female weights Population 2 male weights 128 190 142 145 130 150 133 127 195 165 166 155 112 155 180 180 180 156 155 188 144 220 140 154 143 200 110 210...

    Population 1 Female weights Population 2 male weights 128 190 142 145 130 150 133 127 195 165 166 155 112 155 180 180 180 156 155 188 144 220 140 154 143 200 110 210 160 270 125 250 130 180 150 250 145 240 180 170 175 150 108 155 200 195 151 210 170 155 141 165 200 145 185 190 142 234 125 205 130 151 240 153 160 172 120 200 210 130 220 210...

  • You have two groups of apples (data below). You want to see if there is a...

    You have two groups of apples (data below). You want to see if there is a statistical differnce between the two groups. Run descriptives and a two tailed, two sample assuming equal variance t-test. Here's your data: Weight of Apples in Grams Apple ID Farm A Farm B 1 131 151 2 147 159 3 134 162 4 134 158 5 136 159 6 137 160 7 140 150 8 134 160 9 136 160 10 133 160 11 134...

  • Download the hypothesis testing dataset from the class website. 1. This is case 1, in which...

    Download the hypothesis testing dataset from the class website. 1. This is case 1, in which the value of population standard deviation is assumed to be known. a. Compute the standard deviation of the textbook price and assume this to be the population standard deviation. Type this value in E5. b. Pick a random sample of size 15. c. Compute the mean of your random sample in E4 using the AVERAGE function. d. Calculate the standard error in cell E9...

  • How do I plot a series graph with this data provided? Month 1987 1988 1989 1990...

    How do I plot a series graph with this data provided? Month 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 Jan 95 104 101 88 132 125 111 127 119 147 Feb 94 100 96 110 109 118 123 129 147 146 Mar 98 99 82 129 101 121 121 132 164 133 Apr 96 88 84 113 111 140 139 108 135 148 May 95 89 85 114 140 141 119 115 124 141 Jun 115 108...

  • Bubba's Burgers - Statistics Question

    Sampled StoreDessert Orders Per 1,000 TransactionsStore 1185Store 2226Store 3290Store 4226Store 5255Store 6293Store 7138Store 8203Store 9276Store 10173Store 11275Store 12199Store 13213Store 14321Store 1597Store 16152Store 17319Store 18193Store 19126Store 20215Store 21186Store 22289Store 23181Store 24196Store 25183Store 2690Store 27178Store 28103Store 29173Store 30231Store 31158Store 32202Store 33234Store 34273Store 35218Store 36247Store 37223Store 38108Store 39238Store 40143Store 41206Store 42300Store 4389Store 44202Store 45250Store 46210Store 47137Store 48215Store 49204Store 50188Store 51255Store 52196Store 53123Store 54189Store 55206Store 56146Store 57136Store 58211Store 59164Store 60246Store 61324Store 62125Store 63195Store 64173Store 65179Store 6676Store 67248Store 68199Store 69223Store 70240Store 71224Store 72215Store 73222Store 74170Store...

  • Crop Fertilizer Corn Wheat Rice Soy Blend A 128 123 151 166 150 156 125 178...

    Crop Fertilizer Corn Wheat Rice Soy Blend A 128 123 151 166 150 156 125 178 174 112 117 187 116 100 155 153 109 168 158 195 Blend B 175 135 167 140 132 130 183 145 120 176 142 159 187 120 167 131 184 155 168 126 Blend C 185 156 175 185 138 180 173 206 178 147 154 188 176 146 191 165 190 193 169 188 A company has developed a new fertilizer to...

  • On May 3, 2020, Leven Corp. negotiated a short-term loan of $780,000. The loan is due...

    On May 3, 2020, Leven Corp. negotiated a short-term loan of $780,000. The loan is due October 1, 2020, and carries a 6.20% interest rate. Use ordinary interest to calculate the interest. What is the total amount Leven would pay on the maturity date? (Use Days in a year table.) (Do not round intermediate calculations. Round your answer to the nearest cent.) TABLE 7-1 Exact days-in-a-year calendar (excluding leap year) 31 Day of month Dec. 31 Jan 1 2 3...

  • On May 3, 2020, Leven Corp. negotiated a short-term loan of $900,000. The loan is due...

    On May 3, 2020, Leven Corp. negotiated a short-term loan of $900,000. The loan is due October 1, 2020, and carries a 7.00% interest rate. Use ordinary interest to calculate the interest. What is the total amount Leven would pay on the maturity date? (Use Days in a year table.) (Do not round intermediate calculations. Round your answer to the nearest cent.) TABLE 7-1 Exact days-in-a-year calendar (excluding leap year) 31 Day of month Dec. 31 Jan 1 2 3...

  • Construct a higher order models until you are satisfied you have found the best polynomial model....

    Construct a higher order models until you are satisfied you have found the best polynomial model. Write out your final model or display the analysis window for it so I can see the model you settled on. What is R2-adjusted? Include the Plot of Fitted Model and Residuals versus X output. Predict the highway mileage of a car with 150 horsepower. Also construct 95% confidence and prediction intervals for such a car. Horsepower   MPG Highway 140   31 200   25 172  ...

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