HomeworkLib
Question

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.

  1. Construct a histogram
  2. Create a Five Summary Report
  3. Calculate Mean, Variance and Standard Deviation
  4.   What conclusion can you reach concerning the average credit scores of people living in different American cities?
  5. 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
math   Statistics-And-Probability   
1 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1


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

0 0
Add a comment
Know the answer?
Add Answer to:
Question 2: How do the average credit scores of people living in various cities in the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 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...

  • It's python. Please don't forget to print alpha-sorted states. Not random. Thank you // USPresdients.txt KY  ...

    It's python. Please don't forget to print alpha-sorted states. Not random. Thank you // USPresdients.txt KY   Abraham_Lincoln SC   Andrew_Jackson NC   Andrew_Johnson HI   Barack_Obama OH   Benjamin_Harrison AR   Bill_Clinton VT   Calvin_Coolidge VT   Chester_A_Arthur NY   Donald_Trump TX   Dwight_D_Eisenhower NY   Franklin_D_Roosevelt NH   Franklin_Pierce MA   George_H_W_Bush CT   George_W_Bush VA   George_Washington NE   Gerald_R_Ford NJ   Grover_Cleveland MO   Harry_S_Truman IA   Herbert_Hoover OH   James_A_Garfield PA   James_Buchanan NC   James_K_Polk VA   James_Madison VA   James_Monroe GA   Jimmy_Carter MA   John_Adams MA   John_F_Kennedy MA   John_Quincy_Adams VA   John_Tyler TX   Lyndon_B_Johnson NY   Martin_Van_Buren NY   Millard_Fillmore CA  ...

  • 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT