Generate a correlation matrix and scatterplot matrix test

Assignment Help Management Information Sys

Reference no: EM13478181

The following data were collected from several hospitals and reflect ER visits, bed days, and total expenditures per period of time.

ER Visits	Bed Days	Total Expenditures
1,567	554	$ 10,945,664
1,621	283	$ 6,844,832
3,463	331	$ 8,203,411
5,033	2,137	$ 13,020,058
5,357	2	$ 7,033,959
6,433	81	$ 1,973,125
7,369	207	$ 1,757,830
7,750	121	$ 2,326,256
8,228	74	$ 820,835
8,955	726	$ 13,611,527
11,374	153	$ 2,206,398
13,362	1,093	$ 10,124,680

1. Generate a correlation matrix and a scatterplot matrix.

2. Test the statistical significance of all bivariate correlations at the .05 level. Interpret

3. Test normality of the Total Exp variable. If not normal, transform it.

4. Run a regression model for Total Exp as a function of Total ER Visits and Average Monthly Bed Days.

5. Test the assumptions of regression. Do they hold? If not, what might you do.

6. Interpret all results.

Reference no: EM13478181

Questions Cloud

Write new technology developments in areas of generic and : list the new technology developments in the areas of generic and networked computing and web-based systems. what are

How does use of internet intranets and extranets by : how does the use of internet intranets and extranets by companies today support their business process and activities?

Gve relevant descriptive statistics including graphs run : so lets try a real correlation linear regression model that comes up quite often.try to solve this problem in r. we

Why big companies still fail in their use of information : the success of mis function in any organization will depend upon the relative position of the chief of the mis function

Generate a correlation matrix and scatterplot matrix test : the following data were collected from several hospitals and reflect er visits bed days and total expenditures per

Explain three different types of normalization 1nf 2nf and : explain three different types of normalization 1nf 2nf and 3nf based on their assumptions and requirements within one

What do you believe was underlying motivation of criminal : use the information on the companion web site or other informational resources to locate a recent example of a

Show the finalized complete and reduced decision table : 1 show the finalized complete and reduced decision table using the following table.nbsp conditions and

Using a summary of the six business activities for perfect : data flow diagramusing a summary of the six business activities for perfect pizza as follows create 1 a context diagram

User Account

All Pages