Let’s say you were to roll two dice 1000 times.  What is the number of times you would expect the number 7 to appear?

Question 1.

Let’s say you were to roll two dice 1000 times.  What is the number of times you would expect the number 7 to appear?

 
Flag question: Spacer
You will need to download the 

data_analysis.xlsx


 Download data_analysis.xlsx
worksheet to complete parts of this homework.  Make sure you create backup copies of the data, as you will be asked to answer several questions about the data, and will want the ability to filter, rearrange, and organize the data however you like, to best answer the questions.

 
Flag question: Question 2

Question 2.

The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  For this question, we want you to focus specifically on the 
ash additive.

You should use all of the data in the dataset, but assume that the data is a sample. 
What is the standard deviation (round to the nearest 4 decimal places)?
example 12.33414 –; 12.3341
example 48.39208 –; 48.3921

 
Flag question: Question 3

Question 3.

The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  For this question, we want you to focus specifically on the 
air ent admix additive.

What is the mean (round to the nearest 4 decimal places)?  example 48.39208 –; 48.3921

 
Flag question: Question 4

Question 4.

The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  
Which additive shows the highest relative standard deviation?
Group of answer choices

cement

slag

ash

water

superplastic

air_ent_admix
 
Flag question: Question 5

Question 5.

What can you tell us about how the Coefficient of Variation might be related to skewness?  Use the data from the Analysis1_DescriptiveStats worksheet for your answer.
View keyboard shortcuts
pView keyboard shortcutsAccessibility Checker
0 words
</;Switch to the html editorFullscreen
 
Flag question: Question 6

Question 6.

Use the Analysis2_Correlation worksheet for this question.
Compare the most expensive additive (cement) with the overall Strength. 
What patterns to you see?  Does one have to invest heavily in Cement to achieve a strong concrete mixture?
In a sentence or two, what is happening with any outlier groups?  
View keyboard short

Concrete Data

region cement slag ash water superplastic coarseagg fineagg air ent admix strength
midwest 331 0 0 192 0 879 825 3 13.52
midwest 154 174 185 228 7 845 612 28 24.34
midwest 236.9 91.7 71.5 246.9 6 852.9 695.4 28 28.63
midwest 108.3 162.4 0 203.5 0 938.2 849 3 2.33
midwest 380 95 0 228 0 932 594 7 32.82
midwest 184 86 190 213 6 923 623 28 22.93
midwest 108.3 162.4 0 203.5 0 938.2 849 7 7.72
midwest 170.3 155.5 0 185.7 0 1026.6 724.3 7 10.73
midwest 155 0 143 193 9 877 868 28 9.74
midwest 212 141.3 0 203.5 0 973.4 750 3 6.81
midwest 102 153 0 192 0 887 942 7 7.68
midwest 255 0 0 192 0 889.8 945 3 8.2
midwest 380 95 0 228 0 932 594 28 36.45
midwest 166.8 250.2 0 203.5 0 975.6 692.6 3 6.9
midwest 284 15 141 179 5.5 842 801 7 24.13
midwest 299.8 0 119.8 211.5 9.9 878.2 727.6 28 23.84
midwest 144.8 0 133.6 180.8 11.1 979.5 811.5 28 13.2
midwest 151.6 0 111.9 184.4 7.9 992 815.9 28 12.18
midwest 152 0 112 184 8 992 816 28 Question 1.
Let’s say you were to roll two dice 1000 times.  What is the number of times you would expect the number 7 to appear?
 
Flag question: Spacer
You will need to download the 
            
data_analysis.xlsx

 Download data_analysis.xlsx
            worksheet to complete parts of this homework.  Make sure you create backup copies of the data, as you will be asked to answer several questions about the data, and will want the ability to filter, rearrange, and organize the data however you like, to best answer the questions.
 
Flag question: Question 2
Question 2.
The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  For this question, we want you to focus specifically on the 
            ash additive.
You should use all of the data in the dataset, but assume that the data is a sample. 
What is the standard deviation (round to the nearest 4 decimal places)?
example 12.33414 –; 12.3341
example 48.39208 –; 48.3921
 
Flag question: Question 3
Question 3.
The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  For this question, we want you to focus specifically on the 
            air ent admix additive.
What is the mean (round to the nearest 4 decimal places)?  example 48.39208 –; 48.3921
 
Flag question: Question 4
Question 4.
The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  
Which additive shows the highest relative standard deviation?
Group of answer choices
cement
slag
ash
water
superplastic
air_ent_admix
 
Flag question: Question 5
Question 5.
What can you tell us about how the Coefficient of Variation might be related to skewness?  Use the data from the Analysis1_DescriptiveStats worksheet for your answer.
View keyboard shortcuts
pView keyboard shortcutsAccessibility Checker
0 words
</;Switch to the html editorFullscreen
 
Flag question: Question 6
Question 6.
Use the Analysis2_Correlation worksheet for this question.
Compare the most expensive additive (cement) with the overall Strength. 
What patterns to you see?  Does one have to invest heavily in Cement to achieve a strong concrete mixture?
In a sentence or two, what is happening with any outlier groups?  
View keyboard short
Concrete Data



region
cement
slag
ash
water
superplastic
coarseagg
fineagg
air ent admix
strength


midwest
331
0
0
192
0
879
825
3
13.52


midwest
154
174
185
228
7
845
612
28
24.34


midwest
236.9
91.7
71.5
246.9
6
852.9
695.4
28
28.63


midwest
108.3
162.4
0
203.5
0
938.2
849
3
2.33


midwest
380
95
0
228
0
932
594
7
32.82


midwest
184
86
190
213
6
923
623
28
22.93


midwest
108.3
162.4
0
203.5
0
938.2
849
7
7.72


midwest
170.3
155.5
0
185.7
0
1026.6
724.3
7
10.73


midwest
155
0
143
193
9
877
868
28
9.74


midwest
212
141.3
0
203.5
0
973.4
750
3
6.81


midwest
102
153
0
192
0
887
942
7
7.68


midwest
255
0
0
192
0
889.8
945
3
8.2


midwest
380
95
0
228
0
932
594
28
36.45


midwest
166.8
250.2
0
203.5
0
975.6
692.6
3
6.9


midwest
284
15
141
179
5.5
842
801
7
24.13


midwest
299.8
0
119.8
211.5
9.9
878.2
727.6
28
23.84


midwest
144.8
0
133.6
180.8
11.1
979.5
811.5
28
13.2


midwest
151.6
0
111.9
184.4
7.9
992
815.9
28
12.18


midwest
152
0
112
184
8
992
816
28

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.