a. Generate S curve graphs for five temperatures. The Excel file accompanying this part provides the data
Question:
a. Generate S curve graphs for five temperatures. The Excel file accompanying this part provides the data (fraction of transformation (y) and time (min) for several temperatures (degrees C)). Use this data to generate S type curves (insert Chart and the chart type should be x, y scatter with smooth lines and markers) for every temperature and produce a figure similar to Figure 10.11 in your text (note the log scale x-axis). Items that need to be included are axes titles with units (% and min), and a key indicating the temperatures for each S curve. The y-axis should be from 0 to 100% and x-axis should be from 1 to 1000 min.
b. Generate a graph of ln(rate) (in min-1) vs 1/T (K-1) with data points for the five temperatures. From the S curves in part (a) determine the time (in min) to achieve 50% transformation and the transformation rate (min-1) for each temperature. Include axes titles with units. Your y-axis should be from 0 to -6 and your x-axis should be from 0.0024 to 0.0028. Add a linear trend line and display the equation and the R2 with your chart.
c. Using the information from part (b) above determine the activation energy for this recrystallization process.
d. By extrapolation, estimate the length of time required for 50% recrystallization at 50 degrees C.
Data needed for S curves
Business Statistics a decision making approach
ISBN: 978-0133021844
9th edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry