Home > Forum Home > Analyzing Corporate Financial Data > Regression Analysis for memory retention data
| Share |

Forum Topic | Post Reply Login |

## 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 |

Replies - Displaying 1 to 5 of 5 | Order Replies By: Most Recent | Chronological | Highest Rated |

Rate this: (3/5 from 1 vote) 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 |

Rate this: (3/5 from 1 vote) 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 |

Rate this: (3/5 from 1 vote) | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

Rate this: (3/5 from 1 vote) 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 |

Rate this: (3/5 from 1 vote) | |

Excel Business Forums Administrator | |

Posted by Excel Helper on |

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 |