choose two variables you are interested in. Use regression analysis to test whether there is a relationship between these two variables. Geography Population Government Expenditure ($) Public Debt ($) City of Kenai 7,551 14,099,000 1,530,000 City of Wasilla 8,972 13,629,000 1,224,000 City of Foley 16,741 27,753,000 76,470,000 City of Hoover 84,100 93,696,000 117,775,000 City of Prattville 35,107 26,955,000 40,041,000 City of Hot Springs 36,711 10,477,000 4,119,000 City of Avondale 80,631 45,937,000 63,466,000 City of Coolidge 12,073 9,521,000 3,954,000 City of Douglas 16,764 13,096,000 7,783,000 City of Sedona 10,209 14,908,000 48,119,000 City of Tempe 174,708 186,195,000 328,361,000 City of Baldwin Park 76,511 26,460,000 31,119,000 City of Bell Gardens 42,805 25,869,000 7,963,000 City of Camarillo 66,630 32,828,000 6,465,000 City of Campbell 40,788 42,043,000 17,723,000 City of Dixon 19,144 14,700,000 1,279,000 City of El Cerrito 24,646 31,313,000 21,120,000 City of Fort Bragg 7,260 8,475,000 539,000 City of Half Moon Bay 12,281 8,781,000 10,915,000 City of Hesperia 92,664 26,757,000 37,140,000 City of Lathrop 20,331 19,195,000 4,190,000 City of Newark 44,677 41,230,366 9,563,000 City of Ontario 169,389 203,191,000 69,145,000 City of Pasadena 140,268 204,293,000 204,150,000 City of Pinole 19,040 14,072,000 4,344,000 City of Pismo Beach 7,984 17,031,000 3,040,000 City of Rancho Cucamonga 173,309 74,035,000 1,034,000 City of Red Bluff 14,065 8,763,000 1,664,000 City of Redwood City 82,595 101,684,000 1,712,000 City of Rohnert Park 41,928 35,655,000 1,068,000 City of San Juan Capistrano 36,606 23,531,000 29,651,000 City of San Mateo 102,224 95,779,000 58,005,000 City of Seal Beach 24,510 28,028,000 8,084,000 City of South San Francisco 66,587 86,795,000 12,953,000 City of Sunnyvale 149,596 143,097,000 19,465,000 City of Temecula 108,965 54,191,000 22,563,000 City of Denver 663,303 1,133,387,000 1,143,452,000 City of Arvada 113,532 62,739,000 30,393,000 City of Black Hawk 166 14,351,000 25,330,000 City of Fort Lupton 7,814 9,219,000 2,715,000 City of Greenwood Village 15,208 34,973,000 45,000 City of Lone Tree 12,808 39,747,000 16,764,000 City of Sterling 13,976 13,787,000 564,000 City of Woodland Park 7,180 13,891,000 13,455,000 City of Meriden 60,203 206,667,000 114,446,000 City of Boca Raton 91,702 133,869,000 53,108,000 City of Cape Canaveral 10,116 10,149,000 4,480,000 City of Casselberry 26,649 13,845,000 17,036,000 City of Cocoa Beach 11,466 23,663,000 3,885,000 City of Eustis 19,661 13,805,000 1,105,000 City of Fort Walton Beach 21,238 18,356,000 11,832,000 City of Longwood 14,117 14,819,000 1,186,000 City of North Lauderdale 43,087 22,275,000 2,281,000 City of Safety Harbor 17,268 13,059,000 5,306,000 City of Sanibel 7,044 12,347,000 8,370,000 City of Venice 21,722 26,057,000 5,176,000 City of West Melbourne 20,207 12,328,000 214,000 City of West Palm Beach 104,978 139,286,000 273,535,000 City of Weston 68,893 38,416,000 68,294,000 City of Winter Garden 39,219 28,029,000 29,562,000 City of Canton 25,022 12,445,000 26,389,000 City of Chamblee 27,862 16,410,000 433,000 City of Dunwoody 48,128 18,932,000 11,356,000 City of Griffin 22,875 28,644,000 10,967,000 City of Holly Springs 10,351 5,827,000 3,453,000 City of Powder Springs 14,596 5,902,000 6,290,000 City of St. Marys 17,853 9,724,000 37,745,000 City of Muscatine 23,909 11,486,000 16,093,000 City of Waverly 10,049 6,240,000 21,435,000 City of Post Falls 30,157 16,895,000 3,065,000 City of Batavia 26,413 24,135,000 7,565,000 City of Carbondale 26,066 24,233,000 16,075,000 City of Champaign 84,672 58,478,000 49,530,000 City of Countryside 5,965 11,866,000 20,496,000 City of Genoa 4,930 2,262,000 907,000 City of Lockport 25,096 12,772,000 7,874,000 City of Rolling Meadows 23,377 29,410,000 7,535,000 City of Urbana 41,941 27,756,000 7,915,000 City of Garden City 26,916 20,225,000 30,432,000 City of Leavenworth 35,948 16,940,000 18,535,000 City of Merriam 11,248 12,150,000 4,503,000 City of Prairie Village 21,824 14,948,000 18,629,000 City of Aberdeen 15,361 14,441,000 4,001,000 City of New Carrollton 12,727 8,487,000 2,010,000 City of Saco 19,008 25,958,000 16,175,000 City of Berkley 15,239 9,338,000 1,275,000 City of Dearborn 95,520 109,003,000 4,411,000 City of Marquette 21,282 17,153,000 15,580,000
Correlation
Correlation defines a relationship between two independent variables. It tells the degree to which variables move in relation to each other. When two sets of data are related to each other, there is a correlation between them.
Linear Correlation
A correlation is used to determine the relationships between numerical and categorical variables. In other words, it is an indicator of how things are connected to one another. The correlation analysis is the study of how variables are related.
Regression Analysis
Regression analysis is a statistical method in which it estimates the relationship between a dependent variable and one or more independent variable. In simple terms dependent variable is called as outcome variable and independent variable is called as predictors. Regression analysis is one of the methods to find the trends in data. The independent variable used in Regression analysis is named Predictor variable. It offers data of an associated dependent variable regarding a particular outcome.
choose two variables you are interested in. Use
Geography | Population | Government Expenditure ($) | Public Debt ($) |
City of Kenai | 7,551 | 14,099,000 | 1,530,000 |
City of Wasilla | 8,972 | 13,629,000 | 1,224,000 |
City of Foley | 16,741 | 27,753,000 | 76,470,000 |
City of Hoover | 84,100 | 93,696,000 | 117,775,000 |
City of Prattville | 35,107 | 26,955,000 | 40,041,000 |
City of Hot Springs | 36,711 | 10,477,000 | 4,119,000 |
City of Avondale | 80,631 | 45,937,000 | 63,466,000 |
City of Coolidge | 12,073 | 9,521,000 | 3,954,000 |
City of Douglas | 16,764 | 13,096,000 | 7,783,000 |
City of Sedona | 10,209 | 14,908,000 | 48,119,000 |
City of Tempe | 174,708 | 186,195,000 | 328,361,000 |
City of Baldwin Park | 76,511 | 26,460,000 | 31,119,000 |
City of Bell Gardens | 42,805 | 25,869,000 | 7,963,000 |
City of Camarillo | 66,630 | 32,828,000 | 6,465,000 |
City of Campbell | 40,788 | 42,043,000 | 17,723,000 |
City of Dixon | 19,144 | 14,700,000 | 1,279,000 |
City of El Cerrito | 24,646 | 31,313,000 | 21,120,000 |
City of Fort Bragg | 7,260 | 8,475,000 | 539,000 |
City of Half Moon Bay | 12,281 | 8,781,000 | 10,915,000 |
City of Hesperia | 92,664 | 26,757,000 | 37,140,000 |
City of Lathrop | 20,331 | 19,195,000 | 4,190,000 |
City of Newark | 44,677 | 41,230,366 | 9,563,000 |
City of Ontario | 169,389 | 203,191,000 | 69,145,000 |
City of Pasadena | 140,268 | 204,293,000 | 204,150,000 |
City of Pinole | 19,040 | 14,072,000 | 4,344,000 |
City of Pismo Beach | 7,984 | 17,031,000 | 3,040,000 |
City of Rancho Cucamonga | 173,309 | 74,035,000 | 1,034,000 |
City of Red Bluff | 14,065 | 8,763,000 | 1,664,000 |
City of Redwood City | 82,595 | 101,684,000 | 1,712,000 |
City of Rohnert Park | 41,928 | 35,655,000 | 1,068,000 |
City of San Juan Capistrano | 36,606 | 23,531,000 | 29,651,000 |
City of San Mateo | 102,224 | 95,779,000 | 58,005,000 |
City of Seal Beach | 24,510 | 28,028,000 | 8,084,000 |
City of South San Francisco | 66,587 | 86,795,000 | 12,953,000 |
City of Sunnyvale | 149,596 | 143,097,000 | 19,465,000 |
City of Temecula | 108,965 | 54,191,000 | 22,563,000 |
City of Denver | 663,303 | 1,133,387,000 | 1,143,452,000 |
City of Arvada | 113,532 | 62,739,000 | 30,393,000 |
City of Black Hawk | 166 | 14,351,000 | 25,330,000 |
City of Fort Lupton | 7,814 | 9,219,000 | 2,715,000 |
City of Greenwood Village | 15,208 | 34,973,000 | 45,000 |
City of Lone Tree | 12,808 | 39,747,000 | 16,764,000 |
City of Sterling | 13,976 | 13,787,000 | 564,000 |
City of Woodland Park | 7,180 | 13,891,000 | 13,455,000 |
City of Meriden | 60,203 | 206,667,000 | 114,446,000 |
City of Boca Raton | 91,702 | 133,869,000 | 53,108,000 |
City of Cape Canaveral | 10,116 | 10,149,000 | 4,480,000 |
City of Casselberry | 26,649 | 13,845,000 | 17,036,000 |
City of Cocoa Beach | 11,466 | 23,663,000 | 3,885,000 |
City of Eustis | 19,661 | 13,805,000 | 1,105,000 |
City of Fort Walton Beach | 21,238 | 18,356,000 | 11,832,000 |
City of Longwood | 14,117 | 14,819,000 | 1,186,000 |
City of North Lauderdale | 43,087 | 22,275,000 | 2,281,000 |
City of Safety Harbor | 17,268 | 13,059,000 | 5,306,000 |
City of Sanibel | 7,044 | 12,347,000 | 8,370,000 |
City of Venice | 21,722 | 26,057,000 | 5,176,000 |
City of West Melbourne | 20,207 | 12,328,000 | 214,000 |
City of West Palm Beach | 104,978 | 139,286,000 | 273,535,000 |
City of Weston | 68,893 | 38,416,000 | 68,294,000 |
City of Winter Garden | 39,219 | 28,029,000 | 29,562,000 |
City of Canton | 25,022 | 12,445,000 | 26,389,000 |
City of Chamblee | 27,862 | 16,410,000 | 433,000 |
City of Dunwoody | 48,128 | 18,932,000 | 11,356,000 |
City of Griffin | 22,875 | 28,644,000 | 10,967,000 |
City of Holly Springs | 10,351 | 5,827,000 | 3,453,000 |
City of Powder Springs | 14,596 | 5,902,000 | 6,290,000 |
City of St. Marys | 17,853 | 9,724,000 | 37,745,000 |
City of Muscatine | 23,909 | 11,486,000 | 16,093,000 |
City of Waverly | 10,049 | 6,240,000 | 21,435,000 |
City of Post Falls | 30,157 | 16,895,000 | 3,065,000 |
City of Batavia | 26,413 | 24,135,000 | 7,565,000 |
City of Carbondale | 26,066 | 24,233,000 | 16,075,000 |
City of Champaign | 84,672 | 58,478,000 | 49,530,000 |
City of Countryside | 5,965 | 11,866,000 | 20,496,000 |
City of Genoa | 4,930 | 2,262,000 | 907,000 |
City of Lockport | 25,096 | 12,772,000 | 7,874,000 |
City of Rolling Meadows | 23,377 | 29,410,000 | 7,535,000 |
City of Urbana | 41,941 | 27,756,000 | 7,915,000 |
City of Garden City | 26,916 | 20,225,000 | 30,432,000 |
City of Leavenworth | 35,948 | 16,940,000 | 18,535,000 |
City of Merriam | 11,248 | 12,150,000 | 4,503,000 |
City of Prairie Village | 21,824 | 14,948,000 | 18,629,000 |
City of Aberdeen | 15,361 | 14,441,000 | 4,001,000 |
City of New Carrollton | 12,727 | 8,487,000 | 2,010,000 |
City of Saco | 19,008 | 25,958,000 | 16,175,000 |
City of Berkley | 15,239 | 9,338,000 | 1,275,000 |
City of Dearborn | 95,520 | 109,003,000 | 4,411,000 |
City of Marquette | 21,282 | 17,153,000 | 15,580,000 |
Step by step
Solved in 2 steps with 1 images