Minitab Multiple Regressions Script Help

R

rayuk

#1
I would greatly appreciate it if somebody could help me with a scripting problem I am having with minitab.

I have data for over 100 companies with fields such as ticker, profit, share price, debt, cashflow etc. There is also a time field (indicating what year the data row pertains to). The field "ticker" that uniquely identifies each company. Basically what I would like to do is perform an individual regression for each company for the variable "profit".

If done manually this would entail doing over 100 regressions. I was wondering whether someone has a suggestion on how to automate this process with a script? I have a background as a programmer but I can't find much documentation about scripting in minitab.
 
Elsmar Forum Sponsor
B

Barbara B

#2
rayuk,

you can write macros for Minitab. Basic informations are provided in the thread MiniTab Reporting Capabilities (post #11 and #13). The basic steps are the same for R15 and R16, but R16 provides some new useful commands.

To get the results for the companies seperately, I would use the following commands:
  • Split (get a single worksheet for every company)
  • Worksheet (to select a specific worksheet)
  • Regression or GReg (the first being the command for the menu "regression", the other for "general regression)
with the appropriate settings.

The easiest way to get a syntax is to do 1 analysis manually with the menus, click on the yellow pad in the tool bar (-> Show history) and copy the syntax to a text editor (e.g. Notepad, Notepad++).

You can find all commands and the options for them in the Minitab help files:
Help > Help > Reference: Session commands
There are also some useful tutorial on how to use commands and the different kind of macros Minitab provides.

Hope this helps,

Barbara
 
Thread starter Similar threads Forum Replies Date
P How to do Multiple Regression Analysis in Minitab 16 Using Minitab Software 8
C Creating a Multiple Table SQL (Structured Query Language) Query in Minitab Using Minitab Software 10
A Displaying Multiple Graphs in the Same Plot with Minitab Using Minitab Software 4
F Minitab 19 Anova or X bar # of distinct catagories Using Minitab Software 1
P Pooled Standard Error - Minitab Statistical Analysis Tools, Techniques and SPC 0
S Asterisk in DOE minitab software Using Minitab Software 23
B Does anybody know how to get older versions of Minitab to work in Windows 10? Quality Tools, Improvement and Analysis 9
M Minitab Capability of the Population (no sampling) Using Minitab Software 11
Z Minitab - Updating Graph with specific data points Using Minitab Software 2
S Need help with analysing a survey on minitab Using Minitab Software 1
M Minitab assistant: 1-Sample % Defective Test Using Minitab Software 1
0 Interesting Discussion Analysis of half normal distribution in minitab Using Minitab Software 11
G Batch printing reports in Minitab Using Minitab Software 3
B Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
V Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 9
I Number of decimals in equation calculated by MiniTab Using Minitab Software 0
A Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
M How to change the display of optimization plot in Minitab 18 Using Minitab Software 2
M Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
E Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
N Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
J Including Repeats in DoE using Minitab Using Minitab Software 5
A Minitab 18: How to automate GRR Summary Table save Reliability Analysis - Predictions, Testing and Standards 1
N What subcommands can be used with "Stop" in Minitab 18? Using Minitab Software 8
S Minitab - Factor Analysis: Label on second series of data for Biplot Using Minitab Software 4
J Which Anova dropdown to use for R&R in Minitab? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
J DoE - Number of runs in Plackett-Burman (Minitab) Using Minitab Software 2
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
A Generating samples from a population in Minitab Using Minitab Software 0
Ron Rompen Random data generation in Minitab Statistical Analysis Tools, Techniques and SPC 2
I DOE: High variance and small effects in Minitab Using Minitab Software 1
B Informational Expanded Gage R&R Analysis using Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18
R Rank Deficiency Error Minitab Using Minitab Software 7
H Minitab 15 - Factorial Design - 3 factors: 4x3x2 - How to? Using Minitab Software 4
A Capability Analysis for Packaging Seal Strength with spec. >0.1 Kgf using Minitab Using Minitab Software 6
Coury Ferguson MiniTab 17 Question-Standard Deviation Default Capability, Accuracy and Stability - Processes, Machines, etc. 5
N Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
L MINITAB 17 - Changing Data Using Minitab Software 3
R Conjoint Analysis - Minitab 18 Statistical Analysis Tools, Techniques and SPC 2
F How to make an ANOVA of a design with repeats (not replicates) in Minitab? Using Minitab Software 18
W Definitive screening design in Minitab 17 Manufacturing and Related Processes 1
S Minitab runs at different speeds on identical PCs Using Minitab Software 5
S Response Surface Method to create design matrix in Minitab Using Minitab Software 5
S Minitab limit definition from R & R Using Minitab Software 4
G ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
S Standard Deviation Selection on Control Charts - Minitab "pooled deviation" Statistical Analysis Tools, Techniques and SPC 3
P Minitab Data Analysis - Understanding if a Process is in Control or Not Using Minitab Software 2
P Basic Minitab Help - It's about Linear Regression Using Minitab Software 1
A Taguchi Minitab - Continuous Data - What should I choose as response variable? Using Minitab Software 3
K Taguchi Experiments for Factorial Design Analysis - Reliability of Minitab Results Using Minitab Software 1

Similar threads

Top Bottom