Question 2: How do the average credit scores of people living in various cities in the...
Question 2:
How do the average credit scores of people living in various cities in the US differ? The file Credit Score Data of 143 American cities is provided in Canvas.
- Construct a histogram
- Create a Five Summary Report
- Calculate Mean, Variance and Standard Deviation
- What conclusion can you reach concerning the average credit scores of people living in different American cities?
-
City State Average Credit Score Detroit Mi 743 New York NY 762 Minneapolis MN 787 Hartford CT 774 Atlanta GA 727 Lafayette LA 730 Eugene OR 766 Wichita Falls TX 722 Oklahoma City OK 734 Denver CO 766 Cincinnati OH 763 Jacksonvile FL 728 Amarillo TX 726 Augusta GA 709 El Paso TX 710 Columbus OH 750 Boise ID 754 Rochester NY 767 Paducah KY 731 Toledo OH 750 Memphis TN 711 Tulsa OK 732 Des Moines IA 773 Fargo ND 776 Raleigh NC 743 Spokane WA 765 Salt Lake City UT 760 Knoxville TN 743 Tucson AZ 748 Birmingham AL 731 San Diego CA 753 LaCrosse WI 777 Phoenix AZ 733 Mobile AL 737 St. Louis MO 758 Reno NV 740 Washington DC 766 Tyler TX 710 Santa Barbara CA 771 Savannah GA 716 Beaumont TX 716 Baton Rouge LA 729 Huntsville AL 743 Sacramento CA 745 Madison WI 785 West Palm Beacvh FL 753 Milwaukee WI 765 New Orleans LA 731 Baltimore MD 759 Evansville IN 758 Wilmington NC 745 Kansas City MO 760 Grand Rapids MI 753 Providence RI 764 Charleston WV 732 Charlotte NC 739 Flint MI 747 Waco TX 713 Portland ME 772 Buffalo NY 758 Corpus Christi TX 702 Bakersfield CA 709 Fresno CA 721 Charleston SC 731 Philadelphia PA 760 Scranton PA 759 Topeka KS 764 Springfield MA 758 Ft. Myers FL 750 Greenvile NC 730 Lincoln NE 774 Columbia SC 714 Louisville KY 748 Salisbury MD 750 Omaha NE 767 Wausau WI 789 Indianapolis IN 741 Norfolk VA 740 Sioux Falls SD 778 Davenport IA 769 Albany NY 767 Columbus GA 721 Chattanooga TN 730 Dallas TX 722 Richmond VA 750 Orlando FL 734 Honolulu HI 769 Duluth MN 773 Tallahassee FL 719 Lansing MI 750 Harrisburg PA 776 Myrtle Beach SC 711 Seattle WA 776 Pittsburgh PA 773 Green Bay WI 780 Ft. Wayne IN 747 Palm Springs CA 741 Roanoke VA 752 Nashville TN 740 Monroe LA 706 Harlingen TX 700 Burlington VT 772 Rockford IL 761 Cleveland OH 760 Yakima WA 759 Altoona PA 770 Montgomery AL 712 Youngstown OH 751 Peoria IL 778 Shrevport LA 706 Cedar Rapids IA 781 Tri-Cities TN 738 Macon GA 715 Miami FL 719 Chico CA 754 Chicago IL 760 Tampa FL 740 Wichita KS 749 South Bend IN 753 Greensboro NC 748 Albuquerque NM 728 Las Vegas NV 709 San Francisco CA 781 Jacksonvile MS 701 Lexington KY 739 Columbus MS 717 Greenville SC 740 Champaign IL 754 Monterrey CA 759 Portland OR 768 Boson MA 779 Ft. Smith AK 733 Springfield MO 741 Dayton OH 753 Meford OR 760 Colorado Springs CO 759 San Antonio TX 716 Los Angeles CA 738 Syracuse NY 758 Little Rock AK 727 Austin TX 742 Traverse City MI 758 Houston TX 724
Homework Answers
![1) Histogram Average Credit Score 45 40 35 30 25 15 10 [700, 715] (715, 730] (730, 745 745, 760] (760, 775] (775, 790] Classes of width 15 Five Summary Report Minimum First Quartile Median Third Quartile Maximum 2) 700 730.5 749 762.5 789 (Using Excel function Quartile(data, 1)) (Using Excel function Quartile(data, 2)) (Using Excel function Quartile(data, 3)) 3) Mean Average(data) (Using Excel function Average) 746.2238 Standard Deviation stdev.s(data)(Using Excel function stdev.s) - 21.7807 Variance = (Standard Deviation) (21.7807) 474.3989 Mean-746.2238 Standard Deviation = 21.7807 Variance 474.3989 4) The average credit score of people living in various cities of US is 746.2238 and does not hugely differ because the standard deviation is only 21.7807](http://img.homeworklib.com/questions/34bdae50-41ba-11ea-b736-b589cfa972c6.png?x-oss-process=image/resize,w_560)
Add Answer to:
Question 2: How do the average credit scores of people living in various cities in the...
CPS 276 DOC02-- Assignment 02 Cost of Living Calculator Your client maintains job search website. As...
CPS 276 DOC02-- Assignment 02 Cost of Living Calculator Your
client maintains job search website. As a service on their website,
they need an application that compares costs of living between
different metropolitan areas. Client will pay $780 for a complete
application. Background Information: A person living in an area
with a high cost of living will need higher income to maintain the
same standard of living as someone living in an area with a low
cost of living. For...
TravelAir.com samples domestic airline flights to explore the relationship between airfare and distance. The service would...
TravelAir.com samples domestic airline flights to explore the relationship between airfare and distance. The service would like to know if there is a correlation between airfare and flight distance. If there is a correlation, what percentage of the variation in airfare is accounted for by distance? How much does each additional mile add to the fare? The data follow. Distance Fare 636 $109 2,395 252 2,176 221 605 151 403 138 1,258 209 254 627 259 264 2,342 215 177...
CT 60, 894 NY 1,029,888 MO 245,425 MS 92,831 CO 251,595 ME 60,894 PA 573,815 NE...
CT 60, 894 NY 1,029,888 MO 245,425 MS 92,831 CO 251,595 ME 60,894 PA 573,815 NE 80,432 NC 370,883 ID 64,514 MA 380, 277 IL 574,429 ND 36,863 SC 176,365 MT 45,359 NH 70,699 IN 252,150 SD 38,950 TN 246,025 UT 119, 240 RI 47.731 MI 407,475 AL 165, 716 VA 384,479 WY 25,707 VT 31,284 OH 477, 536 AR 102,755 WV 65,138 AK 37,053 DE 42.655 WI 246,818 FL 876,422 AZ 257,505 CA 1,858,421 DC 44,361 IA 122,914 GA...
and MT NE NV ND NH NJ NM NY NC OH OK OR PA RI SC...
and MT NE NV ND NH NJ NM NY NC OH OK OR PA RI SC SD TN TX UT VA VT WA WV WI WY EM 95813624 7262 1430278 3 22896 03171 12111 1165380 2111211 1.0160 72221 8 tat-AL AK AZ CA CO CN DE DC FL GA HI ID IL IN IA KA KY LA ME MD MA MI MN MS MO ONEC EDA-NSO git M w w M w w E E E E E W W...
With the multiple linear regression equation in (2), what will be the alumni-giving rate with the...
With the multiple linear regression equation in (2), what will
be the alumni-giving rate with the graduation rate as 85%, 60% of
classes with fewer than 20 students, and student-faculty ratio as
12? (20%).
State Graduation Rate 85 79 93 85 75 Alumni Giving Rate 25 % of Classes Student-Faculty Under 20 Ratio 39 13 68 8 60 8 33 40 65 3 10 46 28 67 72 52 8 31 89 90 45 69 72 12 7 13 10...
An article reported the estimated percentage of households with only wireless phone service (no land line)...
An article reported the estimated percentage of households with only wireless phone service (no land line) for the 50 U.S. states and the District of Columbia. In the accompanying data table, each state was also classified into one of three geographical regions—West (W), Middle states (M), and East (E). Wireless % Region State Wireless % Region State 14.9 M AL 10.2 W MT 12.7 W AK 23.2 M NE 19.9 W AZ 10.8 W NV 23.6 M AR 16.9 M...
Suppose we wish to build a multiple regression model to predict the cost of rent (dollars)...
Suppose we wish to build a multiple regression model to predict the cost of rent (dollars) in a city based on population (thousands of people), and income (thousands of dollars). Use the alpha level of 0.05. City Monthly Rent ($) 2018 Population (Thousands) 2010 Median Income (Thousands of Dollars) Denver, CO 998 586.158 45.438 Birmingham, AL 711 212.237 301.704 San Diego, CA 1414 1307.402 61.962 Gainesville, FL 741 124.354 28.653 Winston-Salem, NC 750 239.617 41.979 Memphis, TN 819 646.889 36.535...
CITY Police Officers Non Enrolled/Not Grad Families < Poverty Level Serious Crimes Single Female Parent Households...
CITY
Police Officers
Non Enrolled/Not Grad
Families < Poverty Level
Serious Crimes
Single Female Parent Households
Male Arrests Drugs (%)
Atlanta,
GA
1533
3247
21686
76398
36577
69
Birmingham, AL
724
1891
14075
33895
22391
64
Chicago,
IL
12132
27838
116645
*
197631
69
Cleveland, OH
1682
5262
31340
45610
45455
64
Dallas,
TX
2857
10702
35085
154929
54434
59
Denver,
CO
1361
3312
14417
36558
24215
60
Detroit,
MI
3954
13455
71673
127080
113553
58
Fort
Lauderdale, FL
463...
Business Statistics
Alumni donations are an important source of revenue for college and universities. If administrators could determine the factors that could lead to increases in thepercentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows that students who are moresatisfied with their contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student-faculty ratios mightlead to a higher percentage...
1. Calculate the mean and standard deviation for each variable using formulas or functions. 2. Calculate...
1. Calculate the mean and standard deviation for each variable
using formulas or functions. 2. Calculate descriptive statistics
for each variable using the Analysis Toolpak. 3. Calculate the
coefficient of variation for each variable. What general
interpretation can you make from these values? 4. Calculate the
correlation between Revenue and Employees using a formula.
Calculate the coefficient of determination. 5. Create a correlation
matrix for the eight numerical variables. Note any relationship of
interest
Rank
COMPANY NAME
City
State
Revenue...
CPS 276 DOC02-- Assignment 02 Cost of Living Calculator Your
client maintains job search website. As a service on their website,
they need an application that compares costs of living between
different metropolitan areas. Client will pay $780 for a complete
application. Background Information: A person living in an area
with a high cost of living will need higher income to maintain the
same standard of living as someone living in an area with a low
cost of living. For...
TravelAir.com samples domestic airline flights to explore the relationship between airfare and distance. The service would like to know if there is a correlation between airfare and flight distance. If there is a correlation, what percentage of the variation in airfare is accounted for by distance? How much does each additional mile add to the fare? The data follow. Distance Fare 636 $109 2,395 252 2,176 221 605 151 403 138 1,258 209 254 627 259 264 2,342 215 177...
and MT NE NV ND NH NJ NM NY NC OH OK OR PA RI SC SD TN TX UT VA VT WA WV WI WY EM 95813624 7262 1430278 3 22896 03171 12111 1165380 2111211 1.0160 72221 8 tat-AL AK AZ CA CO CN DE DC FL GA HI ID IL IN IA KA KY LA ME MD MA MI MN MS MO ONEC EDA-NSO git M w w M w w E E E E E W W...
With the multiple linear regression equation in (2), what will
be the alumni-giving rate with the graduation rate as 85%, 60% of
classes with fewer than 20 students, and student-faculty ratio as
12? (20%).
State Graduation Rate 85 79 93 85 75 Alumni Giving Rate 25 % of Classes Student-Faculty Under 20 Ratio 39 13 68 8 60 8 33 40 65 3 10 46 28 67 72 52 8 31 89 90 45 69 72 12 7 13 10...
CITY
Police Officers
Non Enrolled/Not Grad
Families < Poverty Level
Serious Crimes
Single Female Parent Households
Male Arrests Drugs (%)
Atlanta,
GA
1533
3247
21686
76398
36577
69
Birmingham, AL
724
1891
14075
33895
22391
64
Chicago,
IL
12132
27838
116645
*
197631
69
Cleveland, OH
1682
5262
31340
45610
45455
64
Dallas,
TX
2857
10702
35085
154929
54434
59
Denver,
CO
1361
3312
14417
36558
24215
60
Detroit,
MI
3954
13455
71673
127080
113553
58
Fort
Lauderdale, FL
463...
1. Calculate the mean and standard deviation for each variable
using formulas or functions. 2. Calculate descriptive statistics
for each variable using the Analysis Toolpak. 3. Calculate the
coefficient of variation for each variable. What general
interpretation can you make from these values? 4. Calculate the
correlation between Revenue and Employees using a formula.
Calculate the coefficient of determination. 5. Create a correlation
matrix for the eight numerical variables. Note any relationship of
interest
Rank
COMPANY NAME
City
State
Revenue...
Most questions answered within 3 hours.
-
Spam filters try to sort your e-mails, deciding which are real
messages and which are unwanted....
asked 5 minutes ago -
Why is it important to monitor the structural health
of an RCC structure, the codal provisions,...
asked 12 minutes ago -
marcy is trying define aniexty in a way that can be empirically
tested. she is attempting...
asked 27 minutes ago -
A civil engineer has been studying the frequency of vehicle
accidents on a certain stretch of...
asked 35 minutes ago -
A sample of gas contains 0.1300 mol of HBr(g) and 6.500×10-2 mol
of Cl2(g) and occupies...
asked 45 minutes ago -
Case Study 1: Should a Computer Grade Your
Essays?
Would you like your college essays graded...
asked 52 minutes ago -
A 5.0 V potential difference is applied between the ends of a
0.80-mm-diameter, 85-cm-long nichrome wire....
asked 56 minutes ago -
Compilers can have a profound impact on the performance of an
application. Assume that for a...
asked 57 minutes ago -
-4 C of charge are placed on a spherical conducting shell. A
particle with a charge...
asked 1 hour ago -
If you were travelling outward from the earth in a space shuttle
at an altitude of...
asked 1 hour ago -
Write a python program using Object Oriented and do the
following:
1. create class "cat" with...
asked 1 hour ago -
Unida Systems has 37 million shares outstanding trading for $ 12
per share. In addition, Unida...
asked 1 hour ago