Question: * Conduct a descriptive analysis on any 2 interval / ratio variables you wish. Explain the output. * Conduct 3 different hypothesis tests of your

* Conduct a descriptive analysis on any 2 interval / ratio variables you wish. Explain the output.
* Conduct 3 different hypothesis tests of your choice using appropriate variables from the file (note: you must use 3 different tests and not run one test on 3 different variables). In each case, state the variables being tested as well as the hypothesis, decision and conclusion. Use 3 of the following (1-Sample Test for Means, 1-Sample Test for Proportions, 2-Sample Test for Means Independent Samples, 2-Sample Test for Means Paired Samples, 2-Sample Test for Proportions, Analysis of Variance, Chi Square Goodness of Fit Test, Chi Square Test of Independence, Correlation Test).
* Develop a model to predict an interval / ratio variable using at least 2 other variables. Use Multiple_Regression.xls and state the regression model and which variables are or are not significant. Also, use the model to make a prediction by making up values for each of the independent variables.
* Write a one to two page summary of your findings. Include the data file in the appendix.
* Conduct a descriptive analysis on any 2 interval / ratio
variables you wish. Explain the output. * Conduct 3 different hypothesis tests
of your choice using appropriate variables from the file (note: you must
use 3 different tests and not run one test on 3 different
variables). In each case, state the variables being tested as well as
the hypothesis, decision and conclusion. Use 3 of the following (1-Sample Test
please provide all the steps.
County Tested Positive Cases Deaths
Illinois 1228341 133639 6398
Adams 6329 45 1
Alexander 276 17 0
Bond 524 12 1
Boone 4165 537 19
Brown 442 10 0
Bureau 1417 24 1
Calhoun 82 1 0
Carroll 410 20 2
Cass 1186 76 0
Champaign 19946 740 9
Chicago 328930 49776 2427
Christian 1753 39 4
Clark 604 13 0
Clay 512 2 0
Clinton 2840 214 17
Coles 3850 143 17
Cook 271477 35762 1826
Crawford 501 17 0
Cumberland 480 10 0
De Witt 752 4 0
DeKalb 6935 490 15
Douglas 1199 38 0
DuPage 77079 8495 432
Edgar 889 2 0
Edwards 186 2 0
Effingham 1203 9 1
Fayette 967 22 3
Ford 874 22 1
Franklin 2026 12 0
Fulton 1754 12 0
Gallatin 122 2 0
Greene 461 8 0
Grundy 2363 129 2
Hamilton 285 2 0
Hancock 867 18 1
Hardin 102 1 0
Henderson 280 8 0
Henry 2176 72 1
Iroquois 2022 139 5
Jackson 4179 320 15
Jasper 618 46 7
Jefferson 1999 104 16
Jersey 388 29 1
Jo Daviess 778 35 1
Johnson 481 19 0
Kane 47400 7167 232
Kankakee 11560 1096 59
Kendall 8681 891 19
Knox 2478 113 0
Lake 63551 9133 386
LaSalle 5297 183 16
Lawrence 672 4 0
Lee 1768 89 1
Livingston 2019 35 2
Logan 2530 11 0
Macon 5187 212 21
Macoupin 3429 45 2
Madison 10027 740 66
Marion 2195 55 0
Marshall 540 5 0
Mason 1090 18 0
Massac 556 7 0
McDonough 1878 103 15
McHenry 17868 1864 86
McLean 10324 243 13
Menard 988 23 0
Mercer 709 19 0
Monroe 1101 111 12
Montgomery 1937 42 1
Morgan 2499 108 2
Moultrie 571 15 0
Ogle 3166 229 4
Out Of State 7065 111 1
Peoria 13915 397 20
Perry 991 44 0
Piatt 979 11 0
Pike 650 2 0
Pope 97 1 0
Pulaski 348 61 0
Putnam 165 1 0
Randolph 2442 279 7
Richland 560 4 0
Rock Island 9502 757 28
Saline 832 7 0
Sangamon 20356 382 31
Schuyler 438 13 0
Shelby 1079 16 1
St. Clair 12933 1492 117
Stark 200 3 0
Stephenson 3258 231 5
Tazewell 8881 95 6
Unassigned 32185 49 0
Union 1671 174 17
Vermilion 3595 46 1
Wabash 430 14 0
Warren 902 127 0
Washington 574 19 0
Wayne 748 9 1
White 397 3 0
Whiteside 3144 163 15
Will 57606 6191 302
Williamson 3931 87 3
Winnebago 26618 2763 79
Woodford 1867 28 2

County Tested Positive Cases Deaths Illinois 1228341 133639 6398 Adams 6329 45 1 Alexander 276 17 0 Bond 524 12 1 Boone 4165 537 19 Brown 442 10 0 Bureau 1417 24 1 Calhoun 82 1 0 Carroll 410 20 2 Cass 1186 76 0 Champaign 19946 740 9 Chicago 328930 49776 2427 Christian 1753 39 4 Clark 604 13 Clay. 512 0 N Clinton 2840 214 17 Coles 3850 143 17 Cook 271477 35762 1826 Crawford 501 17 0 Cumberland 480 10 0 De Witt 752 4 0 DeKalb 6935 490 15 Douglas 1199 38 0 DuPage 77079 8495 432 Edgar 889 2 0 Edwards 186 2 0 Effingham 1203 9 1 Fayette 967 22 3 Ford 874 22 1 Franklin 2026 12 0 Fulton 1754 12 0 Gallatin 122 2 0 Greene 461 00 0 Grundy. 2363 129 2 Hamilton 285 2 0 Hancock 867 18 Hardin 102 1 0 Henderson 280 8 0 Henry 2176 72 1 Iroquois 2022 139 5 Jackson 4179 320 15 Jasper 618 46 7 Jefferson 1999 104 16 Jersey 388 29 1 Jo Daviess 778 35 1 Johnson 481 19 0 Kane 47400 7167 232 Kankakee 11560 1096 59 Kendall 8681 891 19 Knox 2478 113 0 Lake 63551 9133 386 LaSalle 5297 183 16 Lawrence 672 4 0 Lee 1768 89 1 Livingston 2019 35 2 Logan 2530 11 0 Macon 5187 212 21 Macoupin 3429 45 2 Madison 10027 740 66 Marion 2195 55 0 Marshall 540 5 0 Mason 1090 18 0 o Massac 556 7 McDonough 1878 103 15 McHenry 17868 1864 86 McLean 10324 243 13 Menard 988 23 0 Mercer 709 19 0 Monroe 1101 111 12 Montgomery 1937 42 1 Morgan 2499 108 2 Moultrie 571 15 0 Ogle 3166 229 4 Out Of State 7065 111 1 Peoria 13915 397 20 o Perry 991 44 Piatt 979 11 0 Pike 650 2 0 Pope 97 1 0 Pulaski 348 61 Putnam 165 1 0 Randolph 2442 279 7 Richland 560 4 0 Rock Island 9502 757 28 Saline 832 7 0 Sangamon 20356 382 31 Schuyler 438 13 0 Shelby 1079 16 1 St. Clair 12933 1492 117 Stark 200 3 0 Stephenson 3258 231 5 Tazewell 8881 95 6 Unassigned 32185 49 0 Union 1671 174 17 Vermilion 3595 46 1 Wabash 430 14 0 Warren 902 127 0 Washington 574 19 0 Wayne 748 9 1 White 397 3 0 Whiteside 3144 163 15 Will 57606 6191 302 Williamson 3931 87 3 Winnebago 26618 2763 79 Woodford 1867 28 2 County Tested Positive Cases Deaths Illinois 1228341 133639 6398 Adams 6329 45 1 Alexander 276 17 0 Bond 524 12 1 Boone 4165 537 19 Brown 442 10 0 Bureau 1417 24 1 Calhoun 82 1 0 Carroll 410 20 2 Cass 1186 76 0 Champaign 19946 740 9 Chicago 328930 49776 2427 Christian 1753 39 4 Clark 604 13 Clay. 512 0 N Clinton 2840 214 17 Coles 3850 143 17 Cook 271477 35762 1826 Crawford 501 17 0 Cumberland 480 10 0 De Witt 752 4 0 DeKalb 6935 490 15 Douglas 1199 38 0 DuPage 77079 8495 432 Edgar 889 2 0 Edwards 186 2 0 Effingham 1203 9 1 Fayette 967 22 3 Ford 874 22 1 Franklin 2026 12 0 Fulton 1754 12 0 Gallatin 122 2 0 Greene 461 00 0 Grundy. 2363 129 2 Hamilton 285 2 0 Hancock 867 18 Hardin 102 1 0 Henderson 280 8 0 Henry 2176 72 1 Iroquois 2022 139 5 Jackson 4179 320 15 Jasper 618 46 7 Jefferson 1999 104 16 Jersey 388 29 1 Jo Daviess 778 35 1 Johnson 481 19 0 Kane 47400 7167 232 Kankakee 11560 1096 59 Kendall 8681 891 19 Knox 2478 113 0 Lake 63551 9133 386 LaSalle 5297 183 16 Lawrence 672 4 0 Lee 1768 89 1 Livingston 2019 35 2 Logan 2530 11 0 Macon 5187 212 21 Macoupin 3429 45 2 Madison 10027 740 66 Marion 2195 55 0 Marshall 540 5 0 Mason 1090 18 0 o Massac 556 7 McDonough 1878 103 15 McHenry 17868 1864 86 McLean 10324 243 13 Menard 988 23 0 Mercer 709 19 0 Monroe 1101 111 12 Montgomery 1937 42 1 Morgan 2499 108 2 Moultrie 571 15 0 Ogle 3166 229 4 Out Of State 7065 111 1 Peoria 13915 397 20 o Perry 991 44 Piatt 979 11 0 Pike 650 2 0 Pope 97 1 0 Pulaski 348 61 Putnam 165 1 0 Randolph 2442 279 7 Richland 560 4 0 Rock Island 9502 757 28 Saline 832 7 0 Sangamon 20356 382 31 Schuyler 438 13 0 Shelby 1079 16 1 St. Clair 12933 1492 117 Stark 200 3 0 Stephenson 3258 231 5 Tazewell 8881 95 6 Unassigned 32185 49 0 Union 1671 174 17 Vermilion 3595 46 1 Wabash 430 14 0 Warren 902 127 0 Washington 574 19 0 Wayne 748 9 1 White 397 3 0 Whiteside 3144 163 15 Will 57606 6191 302 Williamson 3931 87 3 Winnebago 26618 2763 79 Woodford 1867 28 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Choose any published database from the internet (such as those from the Census Bureau or any financial or sports sites) or from your workplace. If the file is large than 200 observations, randomly...

Q:

Choose any published database from the internet (such as those from the Census Bureau or any financial or sports sites) or from your workplace. You may opt to use one of the data files provided by...

Q:

UNIT EIGHT: DATA ANALYSIS PROJECT All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below. Format the document professionally...

Q:

UNIT EIGHT: DATA ANALYSIS PROJECT * Choose any published database from the internet or Bethel library (such as those from the Census Bureau or any financial sites). You may opt to use one of the data...

Q:

Choose any published database from the internet (such as those from the Census Bureau or any financial or sports sites) or from your workplace. You may opt to use one of the data files provided by...

Q:

Please help me with finding the right dataset for the analysis Assignment #2 Final Assignment- 25 pts Die at the end of Module a. Choose any published database 1 on the internet (such as loose from...

Q:

please provide a detailed explanation to all the questions Final Assignment Assignment #8. Final Assignment 25 pts. Due at the end of Module 8. . Choose any published database horn the internal (such...

Q:

i would like to get more explanation for these questions please? thank you 1) Conduct a descriptive analysis on any 2 interval /ratio variables you wish using Descriptive_Statistics.xls and...

Q:

Can i get more explanation for this question please? Thank you Conduct a descriptive analysis on any 2 interval /ratio variables you wish using Descriptive_Statistics.xls and...

Q:

Explain each variable in the file that you are analyzing. Be sure your file includes at least 3 scale variables and at least 2 nominal variables. Conduct a descriptive analysis on any 2 interval /...

Q:

a. When a carboxylic acid is dissolved in isotopically labeled water (H2O18), the label is incorporated into both oxygens of the acid. Propose a mechanism to account for this. b. If a carboxylic acid...

Q:

Lymon Properties Group, Inc., is a developer and operator of retail shopping malls. Lymon owns 75 percent of the shares of LDC, Inc., whose business is investing in undeveloped land. All of LDC's...

Q:

True or false: If you find an error on your mortgage statement, wait until next month, then contact your servicer if it's still there. a. True b. False

Q:

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Q:

Teamwork. Picture yourself as the author of the Ask Andy column in your school paper. You receive a letter that says, My boss is always suggesting ways for me to do my job better.When I mentioned...

Q:

Teamwork. Virtual teams are growing as an organizational phenomenon, and web-assisted technologies are being used to facilitate their work.Research several businesses in your city to see whether they...

Q:

For each of the following situations, give a verbal and nonverbal example of a passive reponse, an aggressive response, and an assertive response. (Objective 2) a. You bought a new gas grill at the...