Excel Experiment
docx
keyboard_arrow_up
School
The University of the Virgin Islands *
*We aren’t endorsed by this school
Course
BIO 295
Subject
Mathematics
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by MinisterHawkMaster2381
Part A: Simple Linear Plot
Graph 1:
1.
The data is plotted on the y-axis is: Temperature (K).
2.
The data is plotted on the x-axis is: Volume (L).
3.
The equation of the best-fit trendline to your data: y = 0.1078x - 8.0933
4.
The slope of the trendline: Slope = M = 0.1078
5.
The y-intercept of the trendline: y = 0.0803x
6.
Answer:
The fit of the trendline is good because the R
2
= 0.987, which is above 0.95. When a trendline's R
2
value is at or close to 1, that is when it's the most reliable.
7.
Determine the temperature (in K) of the gas in the cold room when it has a measured volume of 10.5 L using:
A)
Extrapolation and “eyeballing”: 170 K
B)
The equation of the trendline:
y = 0.1078 • x - 8.0933
Volume = 0.1078 • Temperature - 8.0933
10.5 = 0.1078 • T -8.0933
T = (10.5+8.0933)/0.1078 = 172.48 K = 172.5 K
Part B: Two Data Sets with Overlay
Graph 2:
1.
The equation of the best-fit trendline for Data A: y = 1.076x - 0.059
2.
The equation of the best-fit trendline for Data B: y = -3.29x + 3.245
3.
Perform a simultaneous equations calculation to determine the x and y values for the point of intersection between these lines. Show your work below.
y(x) = f(x)
-3.29x + 3.245 = 1.076x – 0.059 | -1.076x
4.366x + 3.245 = -0.059 | -3.245
-4.366x = -3.304 | (-4,366)
x = 0.757 y(0.757) = -3.29 • 0, 757 + 3.245 = 0.755
y = 0.755
Part C: Statistical Analysis and Simple Scatter Plots
y = 0.755
x = 0.757
Graph 3:
1.
For the College #1 data set, record the following values (determined using Excel): A)
The mean SO4 2 concentration: 35.36
B)
The median SO4 2 concentration: 35.05
C)
The standard deviation in the data set:
`
2.
Are there any outliers in the College #1 data set: Yes
A)
If yes, which measurements are the outliers: 43.2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
B)
Show the calculations you used to identify the outliers (or, if none, how you determined that there were none):
Answer:
43.2 – 35.36 = 7.84, which is outside of the Standard Deviation of 3.1904
3.
Re-calculate the following values (using Excel) excluding the outliers: A)
The mean SO4 2 concentration: 34.48
B)
The median SO4 2 concentration:
35
C)
The standard deviation in the data set:
4.
Create a scatter plot (Located Above)
showing both the College #1 and College #2 data. Attach a printout of your graph to this report. Be sure that your axes are properly labeled, and that your graph has an appropriate title. Examine your plotted data. Which data set: A)
Has the larger standard deviation: College 2
B)
Contains the more precise measurements: College 1