You are given an excel spreadsheet that has results of compressive strength of d

Question

You are given an excel spreadsheet that has results of compressive strength of different samples in two sheets of the spreadsheet, which are prepared differently, at different times when testing was performed ( 0 days, 100 days, 200 days). The sample names are shown in the Excel file . You are asked to do the following in a MATLAB script file: 1. Export the necessary data from Excel to Matlab (Assign a variable to each column in Excel to store them in MATLAB). 2. On one plat with the x axis having the Names of the Samples and y axis having the Strength (MPa), plot all three curves. Show x and y labels, legends ( 0 days, 100 days, 2 00 days), title (Comparison Among Different Ages of Samples), assign markers for each, and assign different line types, etc. to distinguish between the three. 3. Prepare 3 barchart plots with the x axis having the Names of the Samples and y axis having the Strength (MPa). The 3 plots will be for 0 , 1 00 , and 200 days. Assign x and y labels and title. 4. Find the standard deviation fo r each set of data. 5. Using the results from 4, plot 3 figures; each one shall show error bars showing the respective amount of standard deviations as the amount of error for all of the points on the curve. You should do this three times for each set of data (at 0 days, 1 00 day s, and 2 00 days)

Explanation / Answer

Program code :

clc
clear all
close all
data = xlsread('Book1.xlsx');
Sno = data(:,1);
data0 = data(:,2);
data100 = data(:,3);
data500 = data(:,4);
figure(1)
hold on
plot(Sno,data0,'-o')
plot(Sno,data100,'-*')
plot(Sno,data500,'->')
legend('0 days','100 days','500 days')
xlabel(' Names of the samples')
ylabel(' Strength in Mpa')
title('Comparison Among Different Ages of Samples')
hold off
figure(2)
Q4FEM = data0;Q4SBFEM = data100;PolyFEM=data500;
bar(1:16, [Q4FEM Q4SBFEM PolyFEM]);
Labels = {'0','0.1','0.2','0.3','0.4','0.5','0.6','0.7','0.8','0.9','1','1.1','1.2','1.3','1.4','1.5'};
set(gca, 'XTick', 1:16, 'XTickLabel', Labels);
xlabel(' Names of the samples')
ylabel(' Strength in Mpa')
legend('0 days','100 days','500 days')
title('Comparison Among Different Ages of Samples')
sd1 = std(data0)
sd2 = std(data100)
sd3 = std(data500)
figure(3)
bar(Sno,data0-sd1)
xlabel(' Names of the samples')
ylabel(' Error')
title(' For 0 days')
figure(4)
bar(Sno,data100-sd1)
xlabel(' Names of the samples')
ylabel(' Error')
title(' For 100 days')
figure(5)
bar(Sno,data500-sd1)
xlabel(' Names of the samples')
ylabel(' Error')
title(' For 500 days')

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.