Question
2) Using Excel, calculate the difference in temperature in Kelvin (T f(k) - T i(K) ) for each row and fill column (D). Enter the
2) Using Excel, calculate the difference in temperature in Kelvin (Tf(k) - Ti(K)) for each row and fill column (D). Enter the formula into cell D3 and hit enter. Click on D3, click on the lower right corner of the cell and drag the formula into the cells beneath. (7 points)
At this point, the graph should populate. The graph displays the change in temperature on the x-axis, and the thermal energy added on the y-axis, with a linear fit of the data.
On the equation for the line of best fit, the number before 'x' is the slope.
Based on the equation provided, with energy on the y-axis and ( Tf (K)- Ti(K) ) on the x-axis, the slope of the graph can be used to determine the specific heat (c) if the mass (m) is known.
Equation of a line ? y=slopex
Specific heat equation ? E=mc(T_f-T_i )
With E as ?y? and (T_f-T_i) as ?x?
?slope=mc
Therefore, the specific heat can be determine as c=slope/mass
File Home Insert Page Layout Formulas Data Review View Help Shape Format Comments Share * 14 + ~ A" A " = Insert General Ex AY O Delete Paste EE $ % " 08 48 Conditional Format as Cell Sort & Find & Sensitivity Formatting * Table Styles Format * * Filter ~ Select Clipboard Font Alignment Number Style Cells Editing Sensitivity TextBox 4 X V D K M W 2 AM AE AC AD AE AF AG AH Al Ad 1 mass = 0.3kg Till = 30OK Specific heat is defined as the amount of heat needed to raise the temperature of 1 kg of a substance 1 degree Kelvin 2 Run Trial OF Ted [KITAK- THE Energy () Calculated c (Jikg.K) (K). We will use data from an experiment to determine the specific heat of an unknown material. 1 80.79 300.26 Last digit of D# 81.41 300.60 45 In an experiment, a 0.3kg black of unknown metal was heated 7 different times. For each run, the black started at 83.21 301.60 175 300K. Different amounts of thermal energy were added to the block as shown in column (E). The final temperatures of 84.83 302.50 the block were recorded in degrees Fahrenheit in column (B). 260 Material Specific Heat 85.73 303.00 340 (/kg . K) 85.19 302.70 Follow the numbered steps below to complete your project Air (at atmospheric pressure) 1007 360 86.27 303.30 380 Aluminum (pure) 903 Note: to receive full credit, the calculations in the steps below must be performed using Excel. Full credit will not be Aluminum alloy-2024-16 (4.5% 875 given for having the correct values in a cell without the proper formula. Change in Temperature vs Thermal Energy copper, 1.5 % Mg, 0.6% Mn) by To maintain the integrity of the project, enter the last digit of your D-number in cell E3 Asphalt 920 (Full name) Bronze (90% copper, 10% 420 1) In column (C), add a formula with a cell reference to column (B) to convert the final temperature of each run to aluminum) Kelvin (K). Enter the formula into cell C3 and hit enter to convert the temperature in B3 to Kelvin. Click on C3, click on Brass (70% copper, 30% zinc) 380 the lower right corner of the cell and drag the formula into the cells beneath. (7 points) Brick (fire clay) 960 Concrete 880 Conversion formula: T(X) = [T('F) - 32] + 3/, + 273.15 Copper (pure) 385 Glass 750 2) Using Excel, calculate the difference in temperature in Kelvin (Tmy - Tun) for each row and fill column (D). Enter the Gold 129 formula into cell D3 and hit enter. Click on D3, click on the lower right corner of the cell and drag the formula into the cells beneath. (7 points) Iron (pure) 447 Stainless steels (AISI 302, 304, 480, 477, 468, At this point, the graph should populate. The graph displays the change in temperature on the x-axis, and the thermal 316, 347) 480 129 D.4 10 energy added on the y-axis, with a linear fit of the data. Lead Change in Temperature [K] Paper 1340 On the equation for the line of best fit, the number before 'x' is the slope. Platinum (pure) 133 Sand 800 Based on the equation provided, with energy on the y-axis and { Trip Too ) on the x-axis, the slope of the graph can be used to determine the specific heat (c) if the mass (m) is known. Silicon 712 Silver 235 Equation of a line - y = slope x x Zinc 389 Water (liquid) 4180 Specific heat equation - E = mc x (7, - I,) With E as 'y' and (T, - To) as 'x' - slope = mc Therefore, the specific heat can be determine as C = = 3) Using Excel and the equation above, determine the specific heat of the material using a formula in cell (H3). (7 points) 4) Based on the value of the specific heat, determine the likely composition of the unknown metal using the table provided. Enter your answer into question 1) below 5) Type your full name into the title of the graph. (5 points) Questions: 1 1 1has Specifc Heat +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started