Answer to the question)
enter the data in excel
sort the data
set the bin values in another column as follows:
.
Now click on data tab
Click on data analysis
In it select histogram
following window appears on screen;
.
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
.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
and a b. Construct a cumultive erente ovon Choose the comect cumulative encentae ooom b ос....
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 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 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 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 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...
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 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 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 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. 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 ...