Question: I need some help with how to do this in excel. I have gone through every question on my own but each of my estimation

I need some help with how to do this in excel. I have gone through every question on my own but each of my estimation types is incredibly far off. The rectangle and trapezoid estimations

I need some help with how to do this in excel. I have gone through every question on my own but each of my estimation types is incredibly far off. The rectangle and trapezoid estimations are close, but the other two are magnitudes smaller. I'm very confused as I am certain I did everything right!

(Problem 2 - use Excel) For this problem, use the following data file on Canvas: HW3P2_Data.xlsx This data represents the measured temperature (T) in a closed container as it is cooled with discrete amounts of heat (Q), while maintaining a constant volume. The entropy change (AS) may be calculated by: dQ AS = Sao Note: This equation shows that Q is the (independent) variable to be integrated. (a) Estimate the entropy change by assuming that the entire amount of heat was transferred at the average temperature of the cylinder: (total AS Tavg (b) Perform a numeric integration to estimate the entropy change [in Joules per Kelvin (J/K)], using left-side rectangles. (c) Perform a numeric integration to estimate the entropy change [in Joules per Kelvin (J/K)], using right- side rectangles. (d) Perform a numeric integration to estimate the entropy change [in Joules per Kelvin (J/K)], using trapezoids. (e) You realize that the data is very closely approximated by AQ aAT. Use Solver to fit the data to find a, and over the whole temperature range to estimate the entropy change [in Joules per Kelvin (J/K)]. then analytically integrate the result (9* dT). Total Heat Change (1) 0 Temperature (K) 500.0 494.0 -70.8 -141.9 488.0 482.0 476.0 -212.1 -282.8 -353 -424.1 -494.1 470.0 464.0 458.0 -564 452.0 -634.2 -704.6 446.0 440.0 434.0 -775.8 -845.8 428.0 -916.4 422.0 416.0 410.0 -986.6 -1057.5 -1127.9 -1198.4 -1268.7 -1338.7 404.0 398.0 392.0 386.0 -1408.4 380.0 374.0 -1479 -1550.1 368.0 -1621 362.0 -1691.7 -1762.8 -1832.9 356.0 350.0 344.0 338.0 332.0 -1903.6 -1973.8 -2044.6 -2115.6 326.0 320.0 (Problem 2 - use Excel) For this problem, use the following data file on Canvas: HW3P2_Data.xlsx This data represents the measured temperature (T) in a closed container as it is cooled with discrete amounts of heat (Q), while maintaining a constant volume. The entropy change (AS) may be calculated by: dQ AS = Sao Note: This equation shows that Q is the (independent) variable to be integrated. (a) Estimate the entropy change by assuming that the entire amount of heat was transferred at the average temperature of the cylinder: (total AS Tavg (b) Perform a numeric integration to estimate the entropy change [in Joules per Kelvin (J/K)], using left-side rectangles. (c) Perform a numeric integration to estimate the entropy change [in Joules per Kelvin (J/K)], using right- side rectangles. (d) Perform a numeric integration to estimate the entropy change [in Joules per Kelvin (J/K)], using trapezoids. (e) You realize that the data is very closely approximated by AQ aAT. Use Solver to fit the data to find a, and over the whole temperature range to estimate the entropy change [in Joules per Kelvin (J/K)]. then analytically integrate the result (9* dT). Total Heat Change (1) 0 Temperature (K) 500.0 494.0 -70.8 -141.9 488.0 482.0 476.0 -212.1 -282.8 -353 -424.1 -494.1 470.0 464.0 458.0 -564 452.0 -634.2 -704.6 446.0 440.0 434.0 -775.8 -845.8 428.0 -916.4 422.0 416.0 410.0 -986.6 -1057.5 -1127.9 -1198.4 -1268.7 -1338.7 404.0 398.0 392.0 386.0 -1408.4 380.0 374.0 -1479 -1550.1 368.0 -1621 362.0 -1691.7 -1762.8 -1832.9 356.0 350.0 344.0 338.0 332.0 -1903.6 -1973.8 -2044.6 -2115.6 326.0 320.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

THIS QUESTION IS DUE IN EXACTLY 1 HOUR AND 45 MINUTES. I WILL PAY EXTRA 10 DOLLARS IN TIP IF SOMEONE TYPES THE EXACT ANSWER REQUESTED. PLEASE RESPOND TO THE EACH AND EVERY QUESTION IN A TOTAL OF 3-4...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

will require integrating human resource management theory and thought (as described in the textbook) while addressing major issues in the field and therefore will require proper referencing and...

Please read the question Question: Choose another different one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That...

Please read the question Question: Choose one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That is, what's the...

will require integrating human resource management theory and thought (as described in the textbook) while addressing major issues in the field and therefore will require proper referencing and...

will require integrating human resource management theory and thought while addressing major issues in the field and therefore will require proper referencing and citations. Please make sure that you...

Based on the article above, answer the following question. 1.What makes ransomware like NotPetya extremely dangerous? 2.What maybe the major motive(s) for its deployment? 3.What makes even big...

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Interviewee: Ithink advertising, like news, provides consumers with specific information about products. This information can help consumers choose products, services, brands and so on. Consumers can...

Flexible budgeting may be viewed as combining the concepts of budgeting with cost-volume-profit analysis.is this true or False

You have a portfolio with 20 calls and 10 puts on the same share. The calls have delta 0.4 and the puts have delta -0.6. Each option is for 100 shares. How many shares would you need to buy or sell...

Why would a company find it beneficial to offer different credit terms to customers?

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What is the basis for Security Concerns in Cloud Computing?

Should Needs and GAP Analyses be equally applied in terms of effort when off-theshelf System Solutions being acquired versus building a custom system using Vendors or internal Programming Staff?

Describe the three main Cloud Computing Environments.