Excel Help for Regression Analysis For Memory Retention Data

Excel Help for Regression Analysis For Memory Retention Data in Analyzing Corporate Financial Data

Regression Analysis For Memory Retention Data

Rate this:

(3/5 from 1 vote)

	I'm super hopeless at maths and need some help. Find the average percentage memory retention (p) measured against passing time (t, in minutes). I need to construct: A scatter plot of p against log(t). The graph needs to indicate a linear straight line relation between average percentage memory retention (p) and passign time (t, in minutes) Add a trend line to add a linear regression line of the form of y=mx+b, where m is the slope and b is the y-intercept Calculate the regression of p using given x values of t. for example p-reg=m*log(t)+b Data set below: t minutes Avg % mem retention (p) 1 0.84 5 0.71 15 0.61 30 0.56 60 0.54 120 0.47 240 0.45 480 0.38 720 0.36 1440 0.26 2880 0.20 5760 0.16 10080 0.08 Does this make sense to anyone??? Please help...thanx
	Posted by CITHelp on 25 Sep 2010

Replies - Displaying 1 to 5 of 5

Order Replies By: Most Recent | Chronological | Highest Rated

	Scatter Pot with Linear Regression Trend Rate this: (3/5 from 1 vote) In this case, you can start by creating a simple XY scatter plot chart from the source data. By selecting the series in the chart you can right click and select Add Trend line > Linear. Right click the Trend Line and choose Form Trend line > Options and choose to add the equation and R-squared on the chart. This will give you the regression equation and the predictive quality (R-squared) for your analysis. To transform or analyze the data before charting, you can use the LOG function and/or other statistical functions such as SLOPE (regression coefficient) under the Statistical functions in Excel.
	Excel Business Forums Administrator
	Posted by Excel Helper on 25 Sep 2010

	Regression Analysis for memory retention data Rate this: (3/5 from 1 vote) Hi, Thanx for that...You rock!. I have created the scatter plot graph. However, i'm still stuck! How do i find log(t) and rep-p??? It's probably very obvious but i can't seem to get the formula. thanx CITHelp
	Posted by CITHelp on 26 Sep 2010

	Logarithmic Trend Line Rate this: (3/5 from 1 vote) Instead of adding the linear trend line to the scatter plot series, you can add a logarithmic trend line. When displaying the equation and r-squared, you will get the Log(t) (where "x" replaces t) and the p-reg is represented by "y" in the equation as the dependent variable of the regression equation.
	Excel Business Forums Administrator
	Posted by Excel Helper on 26 Sep 2010

Regression Analysis for memory retention data

Rate this:

(3/5 from 1 vote)

Hi Excel Helper,

Thanx so much for your help. I need to pick your brain again.

For each of the data lines i need to find log(t) and reg-p....how do i do this???

t minutes            Avg % mem retention (p)        log(t)    reg-p
1                        0.84                                      ?           ?
5                        0.71                                      ?           ?
15                      0.61                                      ?           ?
30                      0.56                                      ?           ?
60                      0.54                                      ?           ?
120                    0.47                                      ?           ? etc
240                    0.45
480                    0.38
720                    0.36
1440                  0.26
2880                  0.20
5760                  0.16
10080                0.08

Posted by CITHelp on 27 Sep 2010

	Using the regression equation Rate this: (3/5 from 1 vote) The view plot the predicted log(t) and p, simply use the calculated regression equation with the original input values.
	Excel Business Forums Administrator
	Posted by Excel Helper on 27 Sep 2010

Displaying page 1 of 1

Find relevant Excel templates and add-ins for Regression Analysis for memory retention data in the Excel Business Solutions Directory

Regression Analysis for memory retention data

Excel Help for Regression Analysis For Memory Retention Data in Analyzing Corporate Financial Data

Regression Analysis For Memory Retention Data