Excel_FillableDoc_W2023

.pdf

School

Washington & Lee University *

*We aren’t endorsed by this school

Course

110

Subject

Chemistry

Date

Apr 3, 2024

Type

pdf

Pages

8

Uploaded by ChiefPowerToad10

© Laurier Department of Chemistry and Biochemistry. No permissions for wider dissemination . WILFRID LAURIER UNIVERSITY CH110 ASSIGNMENT 1 To Excel in Chemistry NAME: Fauzia Ali Hassan STUDENT NUMBER: 169-068-519 DATE SUBMITTED: 24 01,2024 Click here to enter a date. LAB SECTION: L6 Instructions : Fill in the blanks and submit all sheets and required graphs/tables in ONE document only to be uploaded (no .pages or .heic files) to your online CH110 Lab MyLS Excel Assignment dropbox. No other lab report criteria are required for this assignment. Part 1: Simple Linear Plot Which set of data is plotted on the y -axis? Volume of one mole of helium (L) the x -axis? Temperature (K) Record the following information: The equation of the fitted trendline y=0.1026x -6.8464 The value of the slope of this line 0.1026 The value of the y -intercept of this line 6.08464 Is the fit of the trendline to your data a good fit? (Yes or No) Yes Briefly explain your response: As my R^2 is close to 1 then it will be considered to a good fit for my data. Another reason is my data has a liner line and no a sctherefore it indicts that it a good fit. Determine the temperature, in Kelvin, of the gas in the cold room when it has a measured volume of 10.5 L using: a) Extrapolating by graphical means 169 K b) Extrapolating by using the equation of the trendline 6.36K Show your calculations for b) below: y=0.1026x-6.8464 10.5 L= 0.1026x-6.8464 10.5 L = -6.7438x Answer= -1.56 Include (copy and paste) your graph in this report. Be sure that your axes are properly labeled,
© Laurier Department of Chemistry and Biochemistry. No permissions for wider dissemination . with units, the equation of the line and the R 2 value are visible, and that your graph has an approprite title. Click here to enter text. Part 2: Using Functions For the Time of Diffusion versus Temperature plot, why is time plotted on the y -axis? Since all the variables are held constant, diffusion time is shown on the y axis and since the temperature is a dependent variable as it can change at anytime. For the Time of Diffusion versus Temperature plot, which set of data is placed on the left in the Excel worksheet? Time of diffusion is placed on the left in the excel worksheet. What are the R 2 values for the four graphs? Fill-in the table below. Time vs. Temperature Time vs. ln(Temp) Time vs. (Temp) 0.5 Time vs. (Temp) 0.5 R 2 0.913 0.995 0.965 0.9977 Which plot of the four graphs produces the most linear relationship? How do you know? I believe the 4st graph has the most liner because it close to 1 more than the other graphs record. Record the following information: The equation of the trendline for the most linear plot y=107.94x + 1.008 The value of the slope of this line 107.94 y = 0.1026x - 6.8464 R² = 0.987 y = 0.1026x - 6.8464 R² = 0.987 0 5 10 15 20 25 30 35 150 200 250 300 350 400 Volume Of One Mole Of Helium (L) Tempeture (K) Tempeture (K) Verses Volume Of One Of Helium (L)
© Laurier Department of Chemistry and Biochemistry. No permissions for wider dissemination . Include your graphs in this report. Be sure that your axes are properly labeled, with units, the equation of the line and the R 2 value are visible, and that your graph has an appropriate title. y = 107.94x + 1.008 R² = 0.9977 0.0000 2.0000 4.0000 6.0000 8.0000 10.0000 12.0000 0.0000 0.0100 0.0200 0.0300 0.0400 0.0500 0.0600 0.0700 0.0800 0.0900 Time Of Diffusion (ms) Temperature Dependent Inverse Square Root Temperature - Dependent Inverse Square Root Diffusion Trend Chart y = -0.0076x + 10.045 R² = 0.9134 0 2 4 6 8 10 12 Time Of Diffusion (ms) Temperature (K) Thermal Diffusion: Temperature (K) Verses Time Of Diffusion ( ms) trend chart.
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