Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to convert the numbers in column A and column B into values to get a linear relationship
Solved by V. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/09/2018 - 10:41
Welcome to Excelchat, I see that your question is about converting text to values
User
15/09/2018 - 10:41
yes
Excelchat Expert
15/09/2018 - 10:41
I can help you convert text
Excelchat Expert
15/09/2018 - 10:42
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User
15/09/2018 - 10:42
thanks
Excelchat Expert
15/09/2018 - 10:43
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert
15/09/2018 - 10:43
Do you have a sheet to upload or we will use the view screen?
User
15/09/2018 - 10:43
how do I convert the temperature and rate constant data into values that will give me a linear relationship
Excelchat Expert
15/09/2018 - 10:43
Google sheet view scree
User
15/09/2018 - 10:43
I have ended some data into the right hand screen
User
15/09/2018 - 10:44
entered
Excelchat Expert
15/09/2018 - 10:44
I am not sure ?
Excelchat Expert
15/09/2018 - 10:45
for every increase in K you expect what?
User
15/09/2018 - 10:45
I know I have to use a formula but what one?
User
15/09/2018 - 10:46
for temperature increase you expect rate constant increase
User
15/09/2018 - 10:46
all I need to know is what formula I should be using
User
15/09/2018 - 10:46
on excel
Excelchat Expert
15/09/2018 - 10:47
You would have to develop the formula from data , if not a standard exisitng formula
User
15/09/2018 - 10:47
I have the formula ln(k)= - (Ea/R) (1/T) + ln(A)
User
15/09/2018 - 10:47
but idk where that is on excel to do this conversion
User
15/09/2018 - 10:47
but I don't know where that is on excel to do this conversion
Excelchat Expert
15/09/2018 - 10:47
We can start by defining the variables
Excelchat Expert
15/09/2018 - 10:48
In K , is the inverse of K (column A) here?
User
15/09/2018 - 10:48
under the formals tab on excel there are many many formulas available, I'm just not sure which one it is that I should be using??
Excelchat Expert
15/09/2018 - 10:49
Yes, but we need to know what the variables represent in your formula - What is Ea/R ?
User
15/09/2018 - 10:50
A is the frequency factor
User
15/09/2018 - 10:50
which is "k"
Excelchat Expert
15/09/2018 - 10:50
Ok, then that needs to be in excel
User
15/09/2018 - 10:51
Ea is the energy of activation (units of kJ/mol)
User
15/09/2018 - 10:51
R is the thermodynamic gas constant
Excelchat Expert
15/09/2018 - 10:51
we need those variables defined in excel
Excelchat Expert
15/09/2018 - 10:52
EXCEL formulas rely on cell data , regardless of type
User
15/09/2018 - 10:53
I have to convert the temperature and rate constant (shows to the right on the spread sheet) into values that will give me a linear equation (which is the equation I gave above)
User
15/09/2018 - 10:53
I just don't know where that equation can be found on EXCEL
Excelchat Expert
15/09/2018 - 10:55
The only possibility of a defined formula of this type in EXCEL 2016, would be under FORMULAS, MATH&TRIG
Excelchat Expert
15/09/2018 - 10:55
But I dont believe there is a defined formula set up for this type
User
15/09/2018 - 10:55
I'm asking what formula I use for that?
User
15/09/2018 - 10:56
I'm told there is a formula for that?
Excelchat Expert
15/09/2018 - 10:56
Yes, you have one but , need to find cell values to create in EXCEL, if there are defined constants, need those in EXCEL
Excelchat Expert
15/09/2018 - 10:57
Did you check MORE FUNCTIONS, ENGINEERING?
User
15/09/2018 - 10:58
they don't show me the equation or I would have looked for it.. it just says a word and doesn't tell you the actual equation being used
Excelchat Expert
15/09/2018 - 11:00
If you can not enter the values and constants in EXCEL there is no way EXCEL can do this
Excelchat Expert
15/09/2018 - 11:00
There are defined formulas, but if you dont know the name , no way to select.
Excelchat Expert
15/09/2018 - 11:01
I am looking at resources in the archives, but not coming up with any simple answers, but will keep lookiing
User
15/09/2018 - 11:03
I have the values on the right
User
15/09/2018 - 11:03
the formula is for rate constant that has been mathematically changed to show the linear relationship of the rate constant formula
Excelchat Expert
15/09/2018 - 11:04
tjhere is your formula
Excelchat Expert
15/09/2018 - 11:04
all we need to do is plug values from col A and B into the formula
Excelchat Expert
15/09/2018 - 11:05
so which columun = Ea/R?
Excelchat Expert
15/09/2018 - 11:05
Which has T?
Excelchat Expert
15/09/2018 - 11:05
Where do we find A? what cell?
User
15/09/2018 - 11:06
T is col A
User
15/09/2018 - 11:06
R is 8.31x10^-3
User
15/09/2018 - 11:07
k is col B
Excelchat Expert
15/09/2018 - 11:10
Ok, if I got this right..
Excelchat Expert
15/09/2018 - 11:11
take the constant R times the inverse of K , plus rate constant
Excelchat Expert
15/09/2018 - 11:12
Not sure about plus or times the rate constant?
Excelchat Expert
15/09/2018 - 11:13
Wait is this Ln(A) -meaning a log function?
User
15/09/2018 - 11:14
yeah
Excelchat Expert
15/09/2018 - 11:15
Ok, cells and formula is filled in
User
15/09/2018 - 11:15
I'm not sure the value of Ea though
Excelchat Expert
15/09/2018 - 11:15
You can justr copy down
User
15/09/2018 - 11:16
it just tells me Ea is the energy activation (units of kJ/mol)
Excelchat Expert
15/09/2018 - 11:17
I can only help with EXCEL
User
15/09/2018 - 11:19
so is there a formula to use on excel that will do the calculation for me or do I have to do it manually?
Excelchat Expert
15/09/2018 - 11:20
I will check again, but I think this is manual,
User
15/09/2018 - 11:23
thank you
Excelchat Expert
15/09/2018 - 11:24
Yes, you will need the formula inputs and any defined constants, like above and calc manually for this type of equation
User
15/09/2018 - 11:25
I'm told there is a way for EXCEL to do it but okay, thank you
Excelchat Expert
15/09/2018 - 11:26
It can do it , but you need the input values for a defined formula
User
15/09/2018 - 11:26
where do you go to do that?
User
15/09/2018 - 11:26
I'm told to use "EXCEL functions"
Excelchat Expert
15/09/2018 - 11:26
If the formula is not defined you can use graph tools or regression
Excelchat Expert
15/09/2018 - 11:26
This is an EXCEL function
User
15/09/2018 - 11:26
where's that?
Excelchat Expert
15/09/2018 - 11:27
=($G$1) *(1/A2)+log(B2,10)
User
15/09/2018 - 11:27
what's that^?
Excelchat Expert
15/09/2018 - 11:28
That is the formula you gave me with the inputs in column A and B , using a constant in G1
User
15/09/2018 - 11:28
where do I go to find where to put in numbers to have EXCEL do the calculation?
Excelchat Expert
15/09/2018 - 11:29
Your CHEM text?
Excelchat Expert
15/09/2018 - 11:29
Not sure?
User
15/09/2018 - 11:29
you said EXCEL can do calculations if I enter in the numbers.. where is that?
Excelchat Expert
15/09/2018 - 11:29
Where did you get column A , B and this constant ==($G$1) *(1/A2)+log(B2,10)
Excelchat Expert
15/09/2018 - 11:30
sorry this constant==8.31*(10^-3)
User
15/09/2018 - 11:30
on a piece of paper my teacher gave me
Excelchat Expert
15/09/2018 - 11:30
You enter numbers in column A and B
Excelchat Expert
15/09/2018 - 11:30
The formula is in column C
User
15/09/2018 - 11:30
yes from the chart I was given
Excelchat Expert
15/09/2018 - 11:31
The constant is in cell g;1
User
15/09/2018 - 11:31
I don't know where to go on EXCEL to enter in my numbers and have EXCEL do the calculation for me rather than doing it my self manually? you said EXCEL can do the calculation if I enter in the numbers?
Excelchat Expert
15/09/2018 - 11:32
Enter in the numbers in column A and B , as we have in the view screen
User
15/09/2018 - 11:32
and plug them into the equation. I know that but you said EXCEL can do the calculation for me. HOW?
Excelchat Expert
15/09/2018 - 11:32
Copy the formula in column c for every row
Excelchat Expert
15/09/2018 - 11:33
Look at column C
Excelchat Expert
15/09/2018 - 11:34
It uses a constrant R in cell G;1 times the inverse of column A entry , plus the LOG (10) value of the entry in column B.
Excelchat Expert
15/09/2018 - 11:35
Is the formula in E correct and we have the inputs defined then answer is in columN C
Excelchat Expert
15/09/2018 - 11:37
I would question if we really have Ea/R, I think we just have R
User
15/09/2018 - 11:39
we don't have Ea because I'm not sure what that is? My teacher didn't say
Excelchat Expert
15/09/2018 - 11:39
Are you supposed to solve for EA?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.