Prepare a nice bar chart comparing the average compressive and tensile strength of each mix. Plot the average value along with a 95% confidence interval of this average value.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Prepare a nice bar chart comparing the average compressive and tensile strength of each mix.
Plot the average value along with a 95% confidence interval of this average value.

Please show using excel. 
 

 

Mix 1
Mass (g) Compress (psi) Tensile (psi)
192.8
189.4
189.6
181.4
188.2
Mass (g)
171.0
177.3
175.2
177.3
176.3
857
814
688
777
Mix 2
Compress (psi)
667
649
792
673
750
675
738
170.5
165.6
193.1
144.1
163.3
Mix 3
Mass (g) Compress (psi) Tensile (psi)
183.8
175.9
175.8
182.0
176.2
633
773
690
Tensile (psi)
160.7
159.5
124.1
145.1
139.2
191.4
181.0
119.8
Transcribed Image Text:Mix 1 Mass (g) Compress (psi) Tensile (psi) 192.8 189.4 189.6 181.4 188.2 Mass (g) 171.0 177.3 175.2 177.3 176.3 857 814 688 777 Mix 2 Compress (psi) 667 649 792 673 750 675 738 170.5 165.6 193.1 144.1 163.3 Mix 3 Mass (g) Compress (psi) Tensile (psi) 183.8 175.9 175.8 182.0 176.2 633 773 690 Tensile (psi) 160.7 159.5 124.1 145.1 139.2 191.4 181.0 119.8
Mix 4
Mass (g) Compress (psi) Tensile (psi)
188.0
183.8
194.5
182.8
183.1
Mass (g)
168.8
187.8
174.4
184.6
171.5
1057
1142
1334
1336
973
Mix 5
Compress (psi)
1047
1095
1028
1189
591
214.7
175.8
208.4
196.9
163.9
Tensile (psi)
200.2
212.4
215.3
257.0
210.2
Transcribed Image Text:Mix 4 Mass (g) Compress (psi) Tensile (psi) 188.0 183.8 194.5 182.8 183.1 Mass (g) 168.8 187.8 174.4 184.6 171.5 1057 1142 1334 1336 973 Mix 5 Compress (psi) 1047 1095 1028 1189 591 214.7 175.8 208.4 196.9 163.9 Tensile (psi) 200.2 212.4 215.3 257.0 210.2
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman