90.2K

Verified Solution

Link Copied!

can some help fill out the excel

thank you

==-ivy Follow the numbered steps below to complete your project 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. To maintain the integrity of the project, enter the last digit of your D-number in cell E3 1) In column (C), add a formula with a cell reference to column (B) to convert the final temperature of each run to Kelvin (K). Enter the formula into cell C3 and hit enter to convert the temperature in B3 to Kelvin. Click on C3, click on the lower right corner of the cell and drag the formula into the cells beneath. (7 points) Conversion formula: T(K)=[T(aF)32]5/9+273.15 2) Using Excel, calculate the difference in temperature in Kelvin ( TAXITi1KK ) 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 (T+T7x1 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= slope x Specific heat equation E=mc(TfTl) With E as y and (TfTt) as xr slope=mc Therefore, the specificheat can be determine as c=massslope 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 ) 1) What is the likely composition of the metal? How could you contirm your result using the mass and volume of the sample? (8 points) 2) If the mass were doubled, would the temperature increase more or increase less for each run? Explain. (8 points) 3) If the sample was lead, would the temperature increase more or less for each run? Explain. (8 points) Submit your Excel file when completed ==-ivy Follow the numbered steps below to complete your project 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. To maintain the integrity of the project, enter the last digit of your D-number in cell E3 1) In column (C), add a formula with a cell reference to column (B) to convert the final temperature of each run to Kelvin (K). Enter the formula into cell C3 and hit enter to convert the temperature in B3 to Kelvin. Click on C3, click on the lower right corner of the cell and drag the formula into the cells beneath. (7 points) Conversion formula: T(K)=[T(aF)32]5/9+273.15 2) Using Excel, calculate the difference in temperature in Kelvin ( TAXITi1KK ) 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 (T+T7x1 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= slope x Specific heat equation E=mc(TfTl) With E as y and (TfTt) as xr slope=mc Therefore, the specificheat can be determine as c=massslope 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 ) 1) What is the likely composition of the metal? How could you contirm your result using the mass and volume of the sample? (8 points) 2) If the mass were doubled, would the temperature increase more or increase less for each run? Explain. (8 points) 3) If the sample was lead, would the temperature increase more or less for each run? Explain. (8 points) Submit your Excel file when completed

Answer & Explanation Solved by verified expert

See Answer