0
answers
0
watching
98
views
11 Dec 2019

Excel exercise.

The common iron mineral magnetite, Fe3O4 has a similar spinel structure as Co3O4 from our previous homework. This exercise is for the data for magnetite, but you should retrieve your Excel sheet for HW #2, the heat capacity of Co3O4. then simply change data and text as needed to Fe3O4.

For Fe3O4 the HSC data base gives the values of the Cp coefficients A, B, C, D as follows:

A = 415.2

B = −873.7

C = −120.5

D = 800.73

Change your A, B, C, D values as you already are using the cells in your equations to these values for Fe3O4. Your Cp,m column will simply now show the Fe3O4 data. Change your temperature range to 300-800K in steps of 50K (simply delete the rows above 800, also adjust your graph axes!)

Next, in your table with T values (300-800K) and Cp,m values, insert on top a line for T=298. Then add two columns, one for ∆Hf and one for Sm. Look up the values for ∆Hfo and Smo for Fe3O4 in the HSC data base installed on two computers (# 04 and 05) in the chemistry library (B201) and place these values in the cells for T=298K.

Enter the equations for ∆Hf(T) = ∆Hfo + ∫Cp,mdT and S(T) = So + ∫(Cp,m/T) dT in the cells at 300K, then copy down to get the values of these functions up to 800K.

Below on this page first derive the equations for H(T) and S(T) to be coded in on your Excel sheet, using the same values for A, B, C and D given above. We can write Cp,m = a + bT + cT−2 + dT2

with a = A, b = Bx10−3, c = Cx10+5 and d = Dx10−6.

Remember that H(T) = Ho(298) + ∆Hand S(T) = So(298) + ∆S

Your table now will have 4 columns: T (298, 300, 350, …. ,800), Cp,m, ∆Hf and S. On the same one page, add the graphs of Cp,m vs T,∆Hf vs T and S vs T . You will probably need to resize and reposition your previous Excel sheet before printing the new sheet on one page containing the new table and three graphs. =======> H= -1146.20 , S= 153.2

For unlimited access to Homework Help, a Homework+ subscription is required.

discord banner image
Join us on Discord
Chemistry Study Group
Join now

Related textbook solutions

Related questions

Weekly leaderboard

Start filling in the gaps now
Log in