linear regression

  1. S

    Trendline values using Dynamic Range in Excel - comparing with LINEST function

    Hello, I'm going to first explain in detail what I'm getting so that there's not confusion. I have the following data in subsequent columns: time(s), volume(cm3), volume(m3), time/volume(s/m3). So, as you can see, the first 2 columns are 'input type columns', in which I insert the values from...
  2. B

    Confidence interval of linear regression with set y-intercept

    Hi all, I'm looking to calculate and display the confidence interval of a linear regression with y-intercept that is inputted by the user. X is time and the value of the y-intercept will be average of the first timepoint. I've been able to create confidence intervals if the y-intercept is not...
  3. J

    Linear regression in Excel

    I need to use linear regression to get missing data values on Excel in order to normalise the data. E.g. I have 85 values for height (1 missing) and 85 values for shoe size (1 missing). How do I calculate the missing value by using the other 84 (with linear regression)
  4. M

    line of best fit, linear regression, angle of line of best fit - VBA

    Hello,I would greatly appreciate some help with this problem. I am using excel 2003, windows 7.I have been trying to work out which worksheet or vba function to use to calculate the following - but I just can't get the right answer. There are multiple facets to the vba sub I am trying to...
  5. R

    Creating a VBA Macro to Individually Regress Columns B-J All Against Column O with DataAnalysis Tookpack

    Hi guys and gals! I've scoured the internet for a solution, but have yet to find a proper solution. What I want to do is quite simple: individually regress columns B-J (RAD to TPD) against Column O (Mkt-Rf) in my spreadsheet. I really want to use DataAnalysis, too, because it gives me...
  6. D

    Analyzing Attendence Records with Charts and Trend Line Excel 97-2003

    Hi All, I have completed multiple charts and statistical analysis years ago in statistics class and I cannot remember how to do a simple analysis of a multiple year, weekly attendance record. I used the linear chart template and plotted the data that way, but I'd like to take it further and add...
  7. P

    How to create a "training sample"

    I am doing work on a linear regression and the graduate student that is reviewing my work wants me to create a number of worksheets that have a randon sample of the data- say 60% of the rows. Then we fit our model to these different worksheets. Is there such a function or do I need code of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top