Question: Linear Regression from Data Analysis Tool on Excel Problem 1: Linearize the following empirical activity coefficient models and fit the coefficients A and B using

Linear Regression from Data Analysis Tool on Excel Problem 1: Linearize

Linear Regression from Data Analysis Tool on Excel

Problem 1: Linearize the following empirical activity coefficient models and fit the coefficients A and B using the experimental data set given. (Use linear regression) Two parameter Margules Equation ln1=x22(A+3B4Bx2)ln2=x12(A3B+4Bx1) (Ans: approximate values A=1.805 and B=0.655 ) Van Laar Equation ln1ln2=(1+BAx2x1)2A=(1+ABx1x2)2B

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 Chemical Engineering Questions!

The 'Data' tab in your spreadsheet includes 41 measurements of radiation counts through increasing thicknesses of each of two different metals, aluminum (Al) and lead (Pb). The units of measurement...

Question: 1) Create scatter chart of the raw data in a new worksheet. (15 marks)?? ? a. Show all of the values for each of the two dependent variables against the value of the independent variable....

d. Add an exponential trend line for each series, with the equation and the coefficient of deter ination showing for each (1 mark) e With the use of appropriate form itting (titles, bels axes oc...

deacribe the main findings of this paper 400 words (be clear on what the analysis involved says, interpret results, or if you could redo the study, what other varaibles or questions would you...

read this report and answer questions provided: ICTE in Transportation and Logistics 2018 (ICTE 2018) Demand forecasting in pharmaceutical supply chains: A case study Galina Merkuryeva"*, Aija...

Just some points on the main findings of the paper/ what the results mean! 6 67% + T Applying Regression Models to Predict Business Results Jelena Rusov PhD Student Durereado, grade Mirjana Misita...

Philadelphia Modern housing areas often seek to obtain, or at least convey, low rates of crimes. Homeowners and families like to live in safe areas and presumably are willing to pay a premium for the...

Bank of Delaware The National Bank of Delaware County (NBDC), with 12 locations in New York, is an active lender for customers looking to purchase a home, finance a small business, or open a new...

This is an auditing project, it contains excel regression (make sure you have the data analysis function in excel) and 1)you have to post the stores to your Summary Table (which is on the last page...

A discrete-time system is described by y[n] = 6x[n] + 2(x[n+ 1]) a) Find the output of the system, y[n], for 2

Describe & explain the three phases of grieving. Select complicated grief, anticipatory grief, or disenfranchised grief and discuss how personal and situational factors can affect the grief...

The diagram shows a shape drawn on dotty paper. The shape is made from cubes. The measurements of the shape are shown in the diagram. Accurately draw the plan view, front elevation, and side...

Retur A Return B 0.15 6.081 10.1 0.12 0.18 0.13 0.06 0.05 what is the average return of a what is the average retum for stock B WHAT IS THE STANDARD DEVIATION FOR A WHAT IS THE STANDARD DEVIATION...

1. Write down two or three of your greatest strengths.

What roles have these individuals played in your life?

2. Write two or three of your greatest weaknesses.