ANOVA/Regression - Analyzing a Dataset which contains over 4500 Points

S

snickers2190

#1
Hi all,

First timer here. I am hoping this is the right forum and that someone could point me in the right direction.

I am analyzing a dataset which contains over 4500 points. Almost all the independent variables are indicator variables. It so happens that at some levels of the variables, there is no recorded response. For eg., a cross tabulation between Organic and Preservative gives me -

Rows: Organic Columns: Preservative

1 2 All

1 158 0 158
2 1042 2333 3375
3 0 1065 1065
4 60 14 74
All 1260 3412 4672

As you can see I have 0 responses for 2 set of combinations. Because of this, I can not run an ANOVA or a regression model which contains the interaction term between organic and preservative. It is important for our research to look at the interaction terms!

So any advice on how to go about it? My stats prof said there maybe ways to add additional constraints to make the model run, but I wasn't able to find any. Alternatively, I am also open to the idea of running a different statistical analysis to include the interaction term.

Any help would be appreciated Thanks, in advance.
 
Elsmar Forum Sponsor
S

snickers2190

#4
No they are not missing values but zeros (i.e.) they are no recorded values at those levels of organic and preservative.
 
Thread starter Similar threads Forum Replies Date
S Regression Analysis / ANOVA using Excel Excel .xls Spreadsheet Templates and Tools 2
M Understanding of Regression and ANOVA in Minitab Statistical Analysis Tools, Techniques and SPC 8
V Identifying Significant Factors - Regression Analysis vs Correlation vs ANOVA vs DOE Quality Tools, Improvement and Analysis 7
T ANOVA Results ISO 17025 related Discussions 0
B ANOVA 3 level and 4 factors f and p values are not showing Using Minitab Software 0
A R chart from ANOVA gage R&R test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
OpExPro R Squared Values in One-Way ANOVA Statistical Analysis Tools, Techniques and SPC 2
F Minitab 19 Anova or X bar # of distinct catagories Using Minitab Software 2
N % Tolerance - Type 1 study on the gages, then a gage R&R (ANOVA) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
E Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
J Which Anova dropdown to use for R&R in Minitab? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
B WEDM Taguchi and Anova Analysis - L16 array with 5 parameters at 4 levels Manufacturing and Related Processes 9
F How to make an ANOVA of a design with repeats (not replicates) in Minitab? Using Minitab Software 18
G ANOVA GR&R: Minitab vs AIAG MSA results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
H Taguchi mixed model DoE [L16 (4^3 2^6): factors interaction and ANOVA calculation Using Minitab Software 3
S Taguchi Design with ANOVA - 3 factors each with 3 levels Quality Assurance and Compliance Software Tools and Solutions 13
B How to perform a MSA - GRR (Gage R&R) A&R/ANOVA Vs GUM/VDA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
E GR&R ANOVA 3rd Factor for Fixture Nests Using Minitab Software 3
N ANOVA vs 2 sample t-test Statistical Analysis Tools, Techniques and SPC 6
F Help me understand the ANOVA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
F Post Hoc test for two way ANOVA Using Minitab Software 9
E ANOVA for Taguchi method - Four factors and three levels and nine runs (Minitab) Using Minitab Software 8
M ANOVA for S/N ratio gives different results Statistical Analysis Tools, Techniques and SPC 5
T Minitab Two-way Anova example (EXH_AOV.MTB) Quality Assurance and Compliance Software Tools and Solutions 1
P Taguchi Anova Error with Minitab Using Minitab Software 9
J Why doesn't ANOVA Method take the specification into account when determining GR&R % Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
F Fully nested ANOVA: A missing p-values (Minitab) Using Minitab Software 11
C GR&R MSA-4 ANOVA Excel Template Verification Check wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
R P-value and interpretation of ANOVA Gage R & R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
L What is the the difference between the Gage R&R Nested Anova and ISO/REMCO N263? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
S ANOVA and Test Method Validation for a Drug Delivery Device Statistical Analysis Tools, Techniques and SPC 4
L How is the interaction physically happening while performing ANOVA GR&R? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
E Using ANOVA during the PQ Validation Run to evaluate Statistical Differences Statistical Analysis Tools, Techniques and SPC 4
J Minitab Error - * ERROR * Unbalanced Design - Unbalanced Anova Using Minitab Software 9
V Sample Range for a valid GRR using ANOVA in Minitab Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Anova Gage R&R Calculations for 4 Operators Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Multi-factor Anova with Minitab Using Minitab Software 1
R New to MSA - I was told to use ANOVA for the GRR's Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
G GR&R (Gage R&R) Anova versus Xbar Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
J Variation (using ANOVA method) Required for Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
A Minitab ANOVA Error Message - *ERROR* No data in column. Using Minitab Software 3
I Choosing the alpha level in an ANOVA Study Statistical Analysis Tools, Techniques and SPC 3
I Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
P Multi-factor Anova with Minitab Using Minitab Software 11
Rameshwar25 GRR (Gage R&R) Nested Anova Method Example Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 40
L Good Excel .xls sheet for Gage R&R that calculates both Anova and Range Excel .xls Spreadsheet Templates and Tools 9
optomist1 Generic question regarding Two Way ANOVA Results Statistical Analysis Tools, Techniques and SPC 8
D ANOVA vs. X bar & R - MSA Study in Mintab - Which to use and why? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
optomist1 Two Way ANOVA Test For Equal Variances Using Minitab Software 10

Similar threads

Top Bottom