Minitab's Cart Regression in Excel

Bennett1

New Member
Joined
Oct 6, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello everyone. Is there a way to implement Minitab's cart regression in Excel?

I am currently utilizing a proprietary Excel add-in to query data from a database and using VBA to then separate it out to how I need it. I have a year of historical data that I pasted into Minitab to create my model. This model works well but my problem is the end result of my project requires it to exclusively work in excel. As of now my workaround is that I am querying data in Excel and pasting and running it in Minitab then back to Excel. The end goal is for it to be a 'turn on and run' program as it should continually run throughout the day. Any help is appreciated, in particular, if anyone knows a dedicated Minitab forum they can point me towards that would be great.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,214,823
Messages
6,121,780
Members
449,049
Latest member
greyangel23

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