0
   

Regression Using Logs of Variables

 
 
cisaak
 
Reply Thu 12 Dec, 2013 04:15 pm
I have converted 80 ("Count") pairs of X and Y to L10(X) and L10(Y) and performed a regression analysis. Assuming a valid correlation, I know I can predict L10(Y) from a given L10(X) to equal the Y intercept plus slope multiplied by L10(X). I can then convert the predicted L10(Y) to a predicted actual Y by using 10^L10(Y).

My question has to do with determining what I call my confidence interval (may be wrong term). For a confidence interval of 98%, I use the following Excel function: TINV( (1-98%), (Count - 2)) * SQRT( 1/Count + (given L10(X) - average L10(X)) ^2 / SSX). Is the confidence interval produced by this equation an L10()? If yes, then must I convert it to an actual number to compare it to my predicted actual Y?
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 523 • Replies: 0
No top replies

 
 

Related Topics

 
  1. Forums
  2. » Regression Using Logs of Variables
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.07 seconds on 11/15/2024 at 09:58:34