I have secondary data on doctor mistakes (outcome variable) for all 50 states in USA by doctor specialty. I mean real numbers per state. I want to assess the relationship between doctor mistakes (outcome variable) and state of doctor practice (predictor #1) and doctor specialty (Predictor #2) (internist, Surgeon and OBGYN).I want to adjust for the following confounders: provider factor, hospital factor, patient factor and miscellaneous factor. I don't have real data for these 4 confounders.

Hypotheses:

1. no association or interaction between doctor mistake and state of doctor practice

2. no association or interaction between doctor mistake and doctor specialty

I want to do 2-way ANOVA using SPSS and my Excel table currently looks like this (other states not shown here):

State	Doctor Specialty	Doctor Mistake	Doctor Factor	Hospital Factor	Patient Factor	Miscellaneous Factor
Alabama	Internist	100
Alabama	Surgeon	345
Alabama	OBGYN	502
Alaska	Internist	270
Alaska	Surgeon	150
Alaska	OBGYN	39

Questions:

1. Please generate simulated values for the 4 confounders and show the steps (Excel)
2. Please show the steps toconduct sensitivity analyses with different hypothetical scenarios using the generated simulated values for the confounders to understand how varying these factors affects the results. Explain.
3. Test ANOVA Assumptions (Independence, homoscedasticity, and normality) (SPSS). Show Steps
4. Conduct 2-way ANOVA showing all the steps and interpret results (SPSS).
5. Make recommendations for future Study.