File Home Insert Page Layout Formulas Data Review View Help Comments 15 Share Calibri 14 ~ A A = ab General Insert Ex AY O Delete Paste BIU~ Conditional Format as Cell Sort & Find & Sensitivity Formatting * Table Styles * Format Filter ~ Select Clipboard Font Alignment Number Style Cells Editing Sensitivity G6 X V A B C D E F G H K L M N 0 P Q R S T U V w 1 mass = 0.3kg Tinitial = 300K 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 Tfinal( =F) Tfinal (K) Trk) - Tiki Energy (!) Calculated c (J/kg-K) (K). We will use data from an experiment to determine the specific heat of an unknown material. 80.79 300.26 5 81.41 300.60 45 In an experiment, a 0.3kg block of unknown metal was heated 7 different times. For each run, the block started at 300K. 83.21 301.60 175 Different amounts of thermal energy were added to the block as shown in column (E). The final temperatures of the IS WN block were recorded in degrees Fahrenheit in column (B). 3 302.50 260 85.73 303.00 340 Follow the numbered steps below to complete your project 00 85.19 302.70 360 86.27 303.30 380 Note: to receive full credit, the calculations in the steps below must be performed using Excel. Full credit will not be given for having the correct values in a cell without the proper formula Change in Temperature vs Thermal Energy by To maintain the integrity of the project, enter the last digit of your D-number in cell E3 [Full name) 1) In column (C), add a formula with a cell reference to column (B) to convert the final temperature of each run to Kelvin 400 (K). Enter the formula into cell C3 and hit enter to convert the temperature in B3 to Kelvin. Click on C3, click on the 350 lower right corner of the cell and drag the formula into the cells beneath. (7 points) 300 25D Conversion formula: T(K) = [T(OF) - 32] * 5/, + 273.15 Thermal Energy () 200 2) Using Excel, calculate the difference in temperature in Kelvin (Trk) - Tix)) for each row and fill column (D). Enter the 150 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 1DD 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 00 0.2 04 0.6 1.0 12 energy added on the y-axis, with a linear fit of the data. Change in Temperature (K) On the equation for the line of best fit, the number before 'x' is the slope. Material Specific Heat Based on the equation provided, with energy on the y-axis and ( Trix)- Tix) ) on the x-axis, the slope of the graph can be (/kg . K) used to determine the specific heat (c) if the mass (m) is known. Air (at atmospheric pressure) 1007 Aluminum (pure) 903 Equation of a line - y = slope x x Aluminum alloy-2024-T6 (4.5% 875 copper, 1.5 % Mg, 0.6% Mn) Specific heat equation - E = mc x (T, - T;) Asphalt 920 With E as 'y' and (Ty - T;) as 'x' Bronze (90% copper, 10% 420 - clone - me Specifc Heat (+)