Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer question #1 and explain how to get there. D M N 1 Multiple Regression Case (2021) 2 As the cost of college tuition

please answer question #1 and explain how to get there. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
D M N 1 Multiple Regression Case (2021) 2 As the cost of college tuition increases and families of college bound students are facing financial hardships, 3 selection of a college is an important decision. The Department of Education is publishing annual reports that 4 are used by parents, students and high school counselors when searching for the perfect fit". s You are provided with data for a group of 116 colleges and asked to develop a predictive model using multiple regression. 6 The model could then be used to determine the factors that are statistically significant in explaining post-college earnings The model could also be a valuable marketing and branding tool used by college recruiters. 8 For each of the colleges in the sample data, you are given the following: 9 the average post college Earnings (5) 10 the average annual Cost (5) 11 Graduation rate (%) 12 the percentage of students paying down Debt (%) 13 You are asked to show your understanding of multiple regression models and predictive analytics 14 to complete the following tasks. 15 Tasks to complete 16 1 Use step-wise regression to predict Average Postcollege earnings (dependent variable) using cost, graduation rate and percentage of students paying down debt. 18 You will need to use Excel's Data Analysis, Regression tool to generate 4 summary outputs to address each of the following questions (10 points): 19 What is the relationship between the Average Earnings after the graduation and the average Annual Cost? Write down the estimated regression equation 20 What is the relationship between the Average Earnings after the graduation and the Graduation Rate? Write down the estimated regression equation What is the relationship between the Average Earnings after the graduation and the % of students paying Debt? Write down the estimated regression equation. 22 What is the relationship between the Average Earnings after the graduation and all 3 predictor variables considered jointly? Write down the estimated regression equation. Discuss your findings. For each of summary outputs comment on the statistical significance of results (use alpha-0), interpret value of Square, Interpret the values of X coefficients (10 points) What conclusions and recommendations can you derive from your analysis? 27 Be thorough and specific in your analysis. (4 points) 28 Would you recommend using all 3 predictor variables in the final model, if the level of statistical significance alpha is set to .05? If not, explain. (6 points) 29 5 Develop the final model you are recommending to predict Average Earnings after graduation. Provide the Residual Output and discuss the results. 30 Make sure to interpret the value of Rsquare, as well as the values of X coefficients. 31 Piot on a line chart the recorded and predicted Average Earnings after graduation Customize the chart by including your first and last names in the title (8 points) What other independent (predictor) variables could be included in the model to predict the Average Earnings after graduation? Elaborate briefly. (2 points) 17 21 2 23 24 25 26 32 6 34 E F Cost D Graduation rate 22920 23429 19567 25147 21979 29886 34603 28107 23583 34086 19156 31564 Debe 62 73 63 78 78 86 84 65 65 68 61 62 74 80 56 54 81 33821 44800 45100 42300 49200 37900 74900 60600 52900 44000 54500 45200 40400 51800 44100 38600 51900 47600 35900 48300 52100 42300 44400 50900 61100 32300 40800 48100 43600 44500 42800 1 School Earnings 2 St. Ambrose CINC) Albion College (Albion, MI Alfred University (Alfred, NY) 5 Allegheny College (Meadville, PA) 6 Deloit College (Beloit, W) 7 Bentley University (Waltham, MA) Boston University (Boston, MA) 9 California Lutheran University (Thousand Oaks, CA 10 Carroll College (Helena, MT) 11 Catholic University of America (Washington, DC) 12 Cedar Crest College (Allentown, PA) 13 Champlain College (Burlington, VT) 14 Chapman University (Orange, CA) 15 Clark University (Worcester, MA) 16 Colby-Sawyer College (New London, NH) 17 College of Mount St. Vincent (Riverdale, NY) 18 College of St. Benedict St. Joseph, MN) 19 Davis & Elkins College Elkins, WV) 20 DeSales University Center Valley, PA) 21 Dickinson College Carlisle, PA) 22 Doane College (Crete,NE) 23 Dominican University (River Forest, I 24 Drew University Madison, NI) 25 Drexel University (Philadelphia, PA) 26 Earlham College (Richmond, IN) 27 Eckerd College St. Petersburg, FU 28 Elmhurst College Elmhurst, 14) 29 Elmira College (Elmira, NY) 30 Elon University (Elon, NC 31 Endicott College (Beverly, MA) 32 Florida Southern College (Lakeland, FU) 33 Fort Lewis College (Durango, CO) 34 Franklin Pierce University (Rindge, NH) 35 Fresno Pacific University (Fresno, CA) 36 George Fox University (Newberg. OR) 37 Gonzaga University Spokane, WA) 38 Goucher College Baltimore, MD) 39 Gustavus Adolphus College St. Peter, MN) 40 Hawaii Pacific University Honolulu, HI) 41 Hendrix College Conway, AR) 42 Hobart and William Smith Colleges (Geneva, NY) 43 Hollins University Roanoke, VA) 44 Ithaca College (Ithaca, NY) 45 Johnson & Wales University at Denver (Denver, 46 Juniata College (Huntingdon, PA) 47 Kalamazoo College Kalamazoo, MI) 48 Lake Forest College Lake Forest, 10) 49 Lasell College (Newton, MA) 50 Lesley University (Cambridge, MA) 51 Lewis and Clark College (Portland, OR) 52 Unfield College (McMinnville, OR 53 Long Island University - CW. Post Campus Brook 54 Loyola University New Orleans (New Orleans, LA) 55 Lycoming College (Williamsport, PA) 56 Lynn University Boca Raton, FL) 57 Marietta College (Marietta, OH) 58 McDaniel College (Westminster, MD) 59 Menlo College (Atherton, CA) 69 85 62 65 69 67 71 63 74 60 92 87 92 93 98 95 90 95 92 R3 89 87 94 88 85 98 71 90 95 90 86 93 90 96 81 91 89 96 96 82 77 88 81 92 95 91 95 37600 72 57 37 34000 38000 39700 43300 52800 45500 50100 23415 22644 19647 23518 16575 27080 29678 21713 13902 27652 33742 19414 29864 19466 22787 31898 31810 21558 14398 24266 15403 24402 28155 24246 23162 20967 22231 30720 20252 31958 24423 24614 21531 23921 25316 32534 32636 24893 25613 21546 21127 33074 22473 20675 25918 57 63 82 67 83 40 71 78 58 76 54 75 79 67 40500 48600 37000 50400 35100 45200 49400 48100 40900 36700 43400 51300 46000 41300 42800 35500 42600 44600 S0600 87 95 80 96 80 96 93 93 88 86 96 74 46 75 68 41 57 64 41 59 73 38 90 76 89 95 78 D E 38400 39000 40700 50000 45500 35600 44000 43900 41200 58400 49900 61 62 58 74 70 67 41 66 59 59 53 70 32 86 76 58 34700 67 73 65 62 69 68 77 69 60 Meredith College (Raleigh, NC) 61 Mills College (Oakland, CA) 62 Monmouth College (Monmouth, IL) 63 Moravian College (Bethlehem, PA) 64 Nazareth College of Rochester (Rochester, NY) 65 Nebraska Wesleyan University (Lincoln, NE) 66 New England College (Henniker, NH) 67 Niagara University (Niagara University, NY) 68 Oglethorpe University (Atlanta, GA 69 Otterbein University (Westerville, OH) 70 Pace University (New York, NY) 71 Pacific Lutheran University (Tacoma, WA) 72 Pine Manor College (Chestnut Hill, MA) 73 Providence College Providence, RI) 74 Quinnipiac University (Hamden, CT) 75 Regis University (Denver, CO) 76 Rhode Island College (Providence, RI) 77 Rider University Lawrenceville, Nu) 78 Ripon College (Ripon, WI) 79 Roanoke College Salem, VA) 80 Roger Williams University (Bristol, RI) 81 Rollins College (Winter Park, FL) 82 Saint Francis University (Loretto, PA) 83 Seattle University (Seattle, WA) 84 Simmons College (Boston, MA) 85 Spelman College (Atlanta, GA) 86 Springfield College Springfield, MA) 87 Stetson University Ideland, FL) 88 Suffolk University (Boston, MA) 89 Susquehanna University Selinsgrove, PA) 90 Syracuse University Syracuse, NY) 91 Temple University (Philadelphia, PA) 92 The College of Idaho (Caldwell, ID) 93 The College of Wooster (Wooster, OH) 94 The George Washington University (Washington, 95 The University of Tulsa (Tulsa, OK) 96 Trinity University San Antonio, TX) 97 University of Denver (Denver, CO) 98 University of Hartford West Hartford, CT) 99 University of Miami (Coral Gables, FL) 100 University of Puget Sound (Tacoma, WA) 101 University of Redlands (Redlands, CA) 102 University of Rochester (Rochester, NY 103 University of San Diego San Diego, CA) 104 University of San Francisco San Francisco, CA) 105 University of Tampa (Tampa, FL) 106 University of the Pacific Stockton, CA) 107 Wartburg College (Waverly, IA) 108 Washington & Jefferson College (Washington, PA) 109 Washington College (Chestertown, MD) 110 Wells College (Aurora, NY) 111 West Virginia Wesleyan College (Buckhannon, w 112 Western New England University Springfield, MA 113 Whittier College (Whittier, CA) 114 Widener University (Chester, PA) 115 Willamette University Salem, OR) 116 Winthrop University (Rock Hill, SC) 117 Wittenberg University (Springfield, OH) 22275 25539 15685 24730 25936 22204 28458 17437 19721 24850 24961 23486 13735 34841 35159 21046 9938 28210 19254 26451 33838 29427 22593 33557 29085 31293 27674 21815 27507 24954 28912 20845 16681 21455 30206 25702 22389 29362 29140 30394 32115 25057 26608 31593 31915 27955 30318 22124 26491 30255 19739 18292 28517 33181 27387 30312 15311 26616 70 67 64 56 75 81 59600 56400 53100 39600 48100 42800 42500 47200 42200 46900 55200 51400 46400 45100 42600 49900 50000 56600 46500 38900 44400 64500 43200 53200 51400 45900 52400 51500 S3800 55500 56300 61000 44400 66400 43200 49900 48300 33600 43100 55100 45100 51700 49200 36100 42700 87 81 89 91 93 93 78 87 79 86 86 93 52 96 96 85 84 89 90 89 93 83 90 92 93 67 80 86 84 95 93 86 90 91 95 87 96 92 86 90 94 91 93 92 87 87 89 90 93 92 86 82 92 86 83 93 76 90 66 65 75 80 67 81 77 55 81 78 72 85 75 68 59 57 64 76 69 57 59 61 67 56 78 54 64 Earnings Cost 45100 42300 19567 63 25147 78 219178 37900 74900 52900 34603 84 2x107 65 23583 34056 66 1915661 0400 51800 44100 38600 $1900 47600 23415 80 19642 54 23518 81 16375 45 2706 29678 85 21713 62 13902 65 27652 69 33742 67 19414 71 42300 50900 SL100 18100 School SL Ambrose C(NC) Albion College (Albion, MD) Allied University (Alfred, NY) Allegheny College (Meadville, PA) Beloit College (Beloit, WD) Bentley University (Waltham, MA) Boston University (Boston, MA) California Lutheran University (Thousand Oaks, CA) Carroll College (Helena, MT) Catholic University of America (Washington, DC) Coder Crest College (Allentown, PA) Champlain College (Burlington, VT) Chapman University (Orange, CA) Clark University (Worcester, MA) Colby Sawyer College (New London, NH) College of Mount St. Vincent Riverdale, NY) College of St. Benedict (St. Joseph, MN) Davis & Elkins College (Elkins, WV) DeSales University Center Valley, PA) Dickinson College Carlisle, PA) Deane College (Crete.NE) Dominican University River Forest, IL) Drew University (Madison, NJ) Drexel University (Philadelphia, PA) Earliam College (Richmond, IN) Eckard College (St. Petersburg, FL) Filmhurst College (ilmhurst, IL) Elmira College (Elmira, NY) Elon University (Elon, NC) Endicat College (Beverly, MA) Florida Southern College (Lakeland, FL) Fort Lewis College (During, CD) Franklin Pierce University (Rindp, NII) Freno Pacific University (Fresno, CA) George Fex University (Newbery. OR) Gonzaga University (Spokane. WA) Goucher College Baltimore, MD) Gustavus Adolphus College (St. Peter, MN) Hawa Pacific University (Honolulu, HI) Hendrix College (Conway, AR) Hobart and William Smith Colleges (Geneva, NY) Hollins University (Roanoke, VA) Ithaca College (Ithaca, NY) Johnson & Wales University at Denver (Denver, CD) Juniata College (Iluntingdon, PA) Kalamazoo College (Kalamazoo, MI) Lake Forest College (Lake Forest, IL) Lasell College (Newton, MA) Lesley University (Cambridge, MA) Lewis and Clack College Portland, OR) Linfield College (McMinnville, OR) Long Island University-C.W. Post Campus Brookville, NY) Loyola University New Orleans (New Orleans, LA) Lycoming College (Williamsport, PA) Lynn University (loca Raton, FL) Marietta College (Marietta. Olt) McDaniel College (Westminster, MD) Menlo College (Atherton, CA) Meredith College (Raleigh, NC) Mills College (Oskland, CA) Monmouth College (Monmouth, IL) Moravian College (Bethlehem, PA) Nazareth College of Rochester Rochester, NY 44500 12800 37600 34000 19466 74 22767 60 31898 83 31810 72 21556 57 14398 37 15403 57 39700 43300 28155 82 23162 85 50100 43400 3072078 37000 90400 35100 49400 21425 54 24614 75 21531 79 23921 67 25316 49 36700 32636 75 13400 51100 41300 25613 41 215-46 57 21127 64 33034 41 35500 2000 20675 73 506 38400 39000 22275 61 15683 38 24730 74 50000 900 Nazareth College of Rochester (Rochester, NY) Nebraska Wesleyan University (Lincoln, NE) New England College (Henniker, NH) Niagara University (Niagara University, NY) Oglethorpe University (Atlanta, GA Otterbein University (Westerville, OH) Pace University (New York, NY) Pacific Lutheran University (Tacoma, WA) Pine Manor College (Chestnut Hill, MA) Providence College (Providence, RI) Quinnipiac University (Hamden, CT) Regis University (Denver, CO) Rhode Island College (Providence, RI) Rider University (Lawrenceville, NJ) Ripon College (Ripon, WI) Roanoke College (Salem, VA) Roger Williams University (Bristol, RI) Rollins College (Winter Park, FL) Saint Francis University (Loretto, PA) Seattle University (Seattle, WA) Simmons College (Boston, MA) Spelman College (Atlanta, GA Springfield College (Springfield, MA) Stetson University Ideland, FL) Suffolk University (Boston, MA) Susquehanna University (Selinsgrove, PA) Syracuse University (Syracuse, NY) Temple University (Philadelphia, PA) The College of Idaho (Caldwell, ID) The College of Wooster (Wooster, OH) The George Washington University (Washington, DC) The University of Tulsa (Tulsa, OK) Trinity University (San Antonio, TX) University of Denver (Denver, CO) University of Hartford (West Hartford, CT) University of Miami (Coral Gables, FL) University of Puget Sound (Tacoma, WA) University of Redlands (Redlands, CA) University of Rochester (Rochester, NY) University of San Diego (San Diego, CA) University of San Francisco (San Francisco, CA) University of Tampa (Tampa, FL) University of the Pacific (Stockton, CA) Wartburg College (Waverly, IA) Washington & Jefferson College (Washington, PA) Washington College (Chestertown, MD) Wells College (Aurora, NY) West Virginia Wesleyan College (Buckhannon, WV) Western New England University (Springfield, MA) Whittier College (Whittier, CA) Widener University (Chester, PA) Willamette University (Salem, OR) Winthrop University (Rock Hill, SC) Wittenberg University (Springfield, OH) 45500 35600 44000 43900 41200 58400 45900 34700 59600 56400 53100 39600 48100 42800 42500 47200 42200 46900 55200 51400 46400 45100 42600 49900 50000 56600 46500 38900 44400 64500 43200 53200 51400 45900 52400 51500 53800 55500 56300 61000 44400 66400 43200 49900 48300 33600 43100 55100 45100 51700 49200 36100 42700 2593670 22204 67 28458 41 17437 66 19721 59 24850 59 24961 53 23486 70 13735 32 34841 86 35159 76 21046 58 9938 43 28210 67 19254 73 26451 65 33838 62 29427 69 22593 68 33557 77 29085 69 3129370 27674 67 21815 64 27507 56 24954 75 28912 81 20845 66 16681 65 21455 75 30206 80 25702 67 22389 81 29362 77 29140 55 30394 81 3211578 25057 72 26608 85 31593 75 31915 68 27955 59 30318 57 22124 64 26491 76 30255 69 19739 57 18292 59 28517 61 33181 67 27387 56 30312 78 15311 54 26616 64 D M N 1 Multiple Regression Case (2021) 2 As the cost of college tuition increases and families of college bound students are facing financial hardships, 3 selection of a college is an important decision. The Department of Education is publishing annual reports that 4 are used by parents, students and high school counselors when searching for the perfect fit". s You are provided with data for a group of 116 colleges and asked to develop a predictive model using multiple regression. 6 The model could then be used to determine the factors that are statistically significant in explaining post-college earnings The model could also be a valuable marketing and branding tool used by college recruiters. 8 For each of the colleges in the sample data, you are given the following: 9 the average post college Earnings (5) 10 the average annual Cost (5) 11 Graduation rate (%) 12 the percentage of students paying down Debt (%) 13 You are asked to show your understanding of multiple regression models and predictive analytics 14 to complete the following tasks. 15 Tasks to complete 16 1 Use step-wise regression to predict Average Postcollege earnings (dependent variable) using cost, graduation rate and percentage of students paying down debt. 18 You will need to use Excel's Data Analysis, Regression tool to generate 4 summary outputs to address each of the following questions (10 points): 19 What is the relationship between the Average Earnings after the graduation and the average Annual Cost? Write down the estimated regression equation 20 What is the relationship between the Average Earnings after the graduation and the Graduation Rate? Write down the estimated regression equation What is the relationship between the Average Earnings after the graduation and the % of students paying Debt? Write down the estimated regression equation. 22 What is the relationship between the Average Earnings after the graduation and all 3 predictor variables considered jointly? Write down the estimated regression equation. Discuss your findings. For each of summary outputs comment on the statistical significance of results (use alpha-0), interpret value of Square, Interpret the values of X coefficients (10 points) What conclusions and recommendations can you derive from your analysis? 27 Be thorough and specific in your analysis. (4 points) 28 Would you recommend using all 3 predictor variables in the final model, if the level of statistical significance alpha is set to .05? If not, explain. (6 points) 29 5 Develop the final model you are recommending to predict Average Earnings after graduation. Provide the Residual Output and discuss the results. 30 Make sure to interpret the value of Rsquare, as well as the values of X coefficients. 31 Piot on a line chart the recorded and predicted Average Earnings after graduation Customize the chart by including your first and last names in the title (8 points) What other independent (predictor) variables could be included in the model to predict the Average Earnings after graduation? Elaborate briefly. (2 points) 17 21 2 23 24 25 26 32 6 34 E F Cost D Graduation rate 22920 23429 19567 25147 21979 29886 34603 28107 23583 34086 19156 31564 Debe 62 73 63 78 78 86 84 65 65 68 61 62 74 80 56 54 81 33821 44800 45100 42300 49200 37900 74900 60600 52900 44000 54500 45200 40400 51800 44100 38600 51900 47600 35900 48300 52100 42300 44400 50900 61100 32300 40800 48100 43600 44500 42800 1 School Earnings 2 St. Ambrose CINC) Albion College (Albion, MI Alfred University (Alfred, NY) 5 Allegheny College (Meadville, PA) 6 Deloit College (Beloit, W) 7 Bentley University (Waltham, MA) Boston University (Boston, MA) 9 California Lutheran University (Thousand Oaks, CA 10 Carroll College (Helena, MT) 11 Catholic University of America (Washington, DC) 12 Cedar Crest College (Allentown, PA) 13 Champlain College (Burlington, VT) 14 Chapman University (Orange, CA) 15 Clark University (Worcester, MA) 16 Colby-Sawyer College (New London, NH) 17 College of Mount St. Vincent (Riverdale, NY) 18 College of St. Benedict St. Joseph, MN) 19 Davis & Elkins College Elkins, WV) 20 DeSales University Center Valley, PA) 21 Dickinson College Carlisle, PA) 22 Doane College (Crete,NE) 23 Dominican University (River Forest, I 24 Drew University Madison, NI) 25 Drexel University (Philadelphia, PA) 26 Earlham College (Richmond, IN) 27 Eckerd College St. Petersburg, FU 28 Elmhurst College Elmhurst, 14) 29 Elmira College (Elmira, NY) 30 Elon University (Elon, NC 31 Endicott College (Beverly, MA) 32 Florida Southern College (Lakeland, FU) 33 Fort Lewis College (Durango, CO) 34 Franklin Pierce University (Rindge, NH) 35 Fresno Pacific University (Fresno, CA) 36 George Fox University (Newberg. OR) 37 Gonzaga University Spokane, WA) 38 Goucher College Baltimore, MD) 39 Gustavus Adolphus College St. Peter, MN) 40 Hawaii Pacific University Honolulu, HI) 41 Hendrix College Conway, AR) 42 Hobart and William Smith Colleges (Geneva, NY) 43 Hollins University Roanoke, VA) 44 Ithaca College (Ithaca, NY) 45 Johnson & Wales University at Denver (Denver, 46 Juniata College (Huntingdon, PA) 47 Kalamazoo College Kalamazoo, MI) 48 Lake Forest College Lake Forest, 10) 49 Lasell College (Newton, MA) 50 Lesley University (Cambridge, MA) 51 Lewis and Clark College (Portland, OR) 52 Unfield College (McMinnville, OR 53 Long Island University - CW. Post Campus Brook 54 Loyola University New Orleans (New Orleans, LA) 55 Lycoming College (Williamsport, PA) 56 Lynn University Boca Raton, FL) 57 Marietta College (Marietta, OH) 58 McDaniel College (Westminster, MD) 59 Menlo College (Atherton, CA) 69 85 62 65 69 67 71 63 74 60 92 87 92 93 98 95 90 95 92 R3 89 87 94 88 85 98 71 90 95 90 86 93 90 96 81 91 89 96 96 82 77 88 81 92 95 91 95 37600 72 57 37 34000 38000 39700 43300 52800 45500 50100 23415 22644 19647 23518 16575 27080 29678 21713 13902 27652 33742 19414 29864 19466 22787 31898 31810 21558 14398 24266 15403 24402 28155 24246 23162 20967 22231 30720 20252 31958 24423 24614 21531 23921 25316 32534 32636 24893 25613 21546 21127 33074 22473 20675 25918 57 63 82 67 83 40 71 78 58 76 54 75 79 67 40500 48600 37000 50400 35100 45200 49400 48100 40900 36700 43400 51300 46000 41300 42800 35500 42600 44600 S0600 87 95 80 96 80 96 93 93 88 86 96 74 46 75 68 41 57 64 41 59 73 38 90 76 89 95 78 D E 38400 39000 40700 50000 45500 35600 44000 43900 41200 58400 49900 61 62 58 74 70 67 41 66 59 59 53 70 32 86 76 58 34700 67 73 65 62 69 68 77 69 60 Meredith College (Raleigh, NC) 61 Mills College (Oakland, CA) 62 Monmouth College (Monmouth, IL) 63 Moravian College (Bethlehem, PA) 64 Nazareth College of Rochester (Rochester, NY) 65 Nebraska Wesleyan University (Lincoln, NE) 66 New England College (Henniker, NH) 67 Niagara University (Niagara University, NY) 68 Oglethorpe University (Atlanta, GA 69 Otterbein University (Westerville, OH) 70 Pace University (New York, NY) 71 Pacific Lutheran University (Tacoma, WA) 72 Pine Manor College (Chestnut Hill, MA) 73 Providence College Providence, RI) 74 Quinnipiac University (Hamden, CT) 75 Regis University (Denver, CO) 76 Rhode Island College (Providence, RI) 77 Rider University Lawrenceville, Nu) 78 Ripon College (Ripon, WI) 79 Roanoke College Salem, VA) 80 Roger Williams University (Bristol, RI) 81 Rollins College (Winter Park, FL) 82 Saint Francis University (Loretto, PA) 83 Seattle University (Seattle, WA) 84 Simmons College (Boston, MA) 85 Spelman College (Atlanta, GA) 86 Springfield College Springfield, MA) 87 Stetson University Ideland, FL) 88 Suffolk University (Boston, MA) 89 Susquehanna University Selinsgrove, PA) 90 Syracuse University Syracuse, NY) 91 Temple University (Philadelphia, PA) 92 The College of Idaho (Caldwell, ID) 93 The College of Wooster (Wooster, OH) 94 The George Washington University (Washington, 95 The University of Tulsa (Tulsa, OK) 96 Trinity University San Antonio, TX) 97 University of Denver (Denver, CO) 98 University of Hartford West Hartford, CT) 99 University of Miami (Coral Gables, FL) 100 University of Puget Sound (Tacoma, WA) 101 University of Redlands (Redlands, CA) 102 University of Rochester (Rochester, NY 103 University of San Diego San Diego, CA) 104 University of San Francisco San Francisco, CA) 105 University of Tampa (Tampa, FL) 106 University of the Pacific Stockton, CA) 107 Wartburg College (Waverly, IA) 108 Washington & Jefferson College (Washington, PA) 109 Washington College (Chestertown, MD) 110 Wells College (Aurora, NY) 111 West Virginia Wesleyan College (Buckhannon, w 112 Western New England University Springfield, MA 113 Whittier College (Whittier, CA) 114 Widener University (Chester, PA) 115 Willamette University Salem, OR) 116 Winthrop University (Rock Hill, SC) 117 Wittenberg University (Springfield, OH) 22275 25539 15685 24730 25936 22204 28458 17437 19721 24850 24961 23486 13735 34841 35159 21046 9938 28210 19254 26451 33838 29427 22593 33557 29085 31293 27674 21815 27507 24954 28912 20845 16681 21455 30206 25702 22389 29362 29140 30394 32115 25057 26608 31593 31915 27955 30318 22124 26491 30255 19739 18292 28517 33181 27387 30312 15311 26616 70 67 64 56 75 81 59600 56400 53100 39600 48100 42800 42500 47200 42200 46900 55200 51400 46400 45100 42600 49900 50000 56600 46500 38900 44400 64500 43200 53200 51400 45900 52400 51500 S3800 55500 56300 61000 44400 66400 43200 49900 48300 33600 43100 55100 45100 51700 49200 36100 42700 87 81 89 91 93 93 78 87 79 86 86 93 52 96 96 85 84 89 90 89 93 83 90 92 93 67 80 86 84 95 93 86 90 91 95 87 96 92 86 90 94 91 93 92 87 87 89 90 93 92 86 82 92 86 83 93 76 90 66 65 75 80 67 81 77 55 81 78 72 85 75 68 59 57 64 76 69 57 59 61 67 56 78 54 64 Earnings Cost 45100 42300 19567 63 25147 78 219178 37900 74900 52900 34603 84 2x107 65 23583 34056 66 1915661 0400 51800 44100 38600 $1900 47600 23415 80 19642 54 23518 81 16375 45 2706 29678 85 21713 62 13902 65 27652 69 33742 67 19414 71 42300 50900 SL100 18100 School SL Ambrose C(NC) Albion College (Albion, MD) Allied University (Alfred, NY) Allegheny College (Meadville, PA) Beloit College (Beloit, WD) Bentley University (Waltham, MA) Boston University (Boston, MA) California Lutheran University (Thousand Oaks, CA) Carroll College (Helena, MT) Catholic University of America (Washington, DC) Coder Crest College (Allentown, PA) Champlain College (Burlington, VT) Chapman University (Orange, CA) Clark University (Worcester, MA) Colby Sawyer College (New London, NH) College of Mount St. Vincent Riverdale, NY) College of St. Benedict (St. Joseph, MN) Davis & Elkins College (Elkins, WV) DeSales University Center Valley, PA) Dickinson College Carlisle, PA) Deane College (Crete.NE) Dominican University River Forest, IL) Drew University (Madison, NJ) Drexel University (Philadelphia, PA) Earliam College (Richmond, IN) Eckard College (St. Petersburg, FL) Filmhurst College (ilmhurst, IL) Elmira College (Elmira, NY) Elon University (Elon, NC) Endicat College (Beverly, MA) Florida Southern College (Lakeland, FL) Fort Lewis College (During, CD) Franklin Pierce University (Rindp, NII) Freno Pacific University (Fresno, CA) George Fex University (Newbery. OR) Gonzaga University (Spokane. WA) Goucher College Baltimore, MD) Gustavus Adolphus College (St. Peter, MN) Hawa Pacific University (Honolulu, HI) Hendrix College (Conway, AR) Hobart and William Smith Colleges (Geneva, NY) Hollins University (Roanoke, VA) Ithaca College (Ithaca, NY) Johnson & Wales University at Denver (Denver, CD) Juniata College (Iluntingdon, PA) Kalamazoo College (Kalamazoo, MI) Lake Forest College (Lake Forest, IL) Lasell College (Newton, MA) Lesley University (Cambridge, MA) Lewis and Clack College Portland, OR) Linfield College (McMinnville, OR) Long Island University-C.W. Post Campus Brookville, NY) Loyola University New Orleans (New Orleans, LA) Lycoming College (Williamsport, PA) Lynn University (loca Raton, FL) Marietta College (Marietta. Olt) McDaniel College (Westminster, MD) Menlo College (Atherton, CA) Meredith College (Raleigh, NC) Mills College (Oskland, CA) Monmouth College (Monmouth, IL) Moravian College (Bethlehem, PA) Nazareth College of Rochester Rochester, NY 44500 12800 37600 34000 19466 74 22767 60 31898 83 31810 72 21556 57 14398 37 15403 57 39700 43300 28155 82 23162 85 50100 43400 3072078 37000 90400 35100 49400 21425 54 24614 75 21531 79 23921 67 25316 49 36700 32636 75 13400 51100 41300 25613 41 215-46 57 21127 64 33034 41 35500 2000 20675 73 506 38400 39000 22275 61 15683 38 24730 74 50000 900 Nazareth College of Rochester (Rochester, NY) Nebraska Wesleyan University (Lincoln, NE) New England College (Henniker, NH) Niagara University (Niagara University, NY) Oglethorpe University (Atlanta, GA Otterbein University (Westerville, OH) Pace University (New York, NY) Pacific Lutheran University (Tacoma, WA) Pine Manor College (Chestnut Hill, MA) Providence College (Providence, RI) Quinnipiac University (Hamden, CT) Regis University (Denver, CO) Rhode Island College (Providence, RI) Rider University (Lawrenceville, NJ) Ripon College (Ripon, WI) Roanoke College (Salem, VA) Roger Williams University (Bristol, RI) Rollins College (Winter Park, FL) Saint Francis University (Loretto, PA) Seattle University (Seattle, WA) Simmons College (Boston, MA) Spelman College (Atlanta, GA Springfield College (Springfield, MA) Stetson University Ideland, FL) Suffolk University (Boston, MA) Susquehanna University (Selinsgrove, PA) Syracuse University (Syracuse, NY) Temple University (Philadelphia, PA) The College of Idaho (Caldwell, ID) The College of Wooster (Wooster, OH) The George Washington University (Washington, DC) The University of Tulsa (Tulsa, OK) Trinity University (San Antonio, TX) University of Denver (Denver, CO) University of Hartford (West Hartford, CT) University of Miami (Coral Gables, FL) University of Puget Sound (Tacoma, WA) University of Redlands (Redlands, CA) University of Rochester (Rochester, NY) University of San Diego (San Diego, CA) University of San Francisco (San Francisco, CA) University of Tampa (Tampa, FL) University of the Pacific (Stockton, CA) Wartburg College (Waverly, IA) Washington & Jefferson College (Washington, PA) Washington College (Chestertown, MD) Wells College (Aurora, NY) West Virginia Wesleyan College (Buckhannon, WV) Western New England University (Springfield, MA) Whittier College (Whittier, CA) Widener University (Chester, PA) Willamette University (Salem, OR) Winthrop University (Rock Hill, SC) Wittenberg University (Springfield, OH) 45500 35600 44000 43900 41200 58400 45900 34700 59600 56400 53100 39600 48100 42800 42500 47200 42200 46900 55200 51400 46400 45100 42600 49900 50000 56600 46500 38900 44400 64500 43200 53200 51400 45900 52400 51500 53800 55500 56300 61000 44400 66400 43200 49900 48300 33600 43100 55100 45100 51700 49200 36100 42700 2593670 22204 67 28458 41 17437 66 19721 59 24850 59 24961 53 23486 70 13735 32 34841 86 35159 76 21046 58 9938 43 28210 67 19254 73 26451 65 33838 62 29427 69 22593 68 33557 77 29085 69 3129370 27674 67 21815 64 27507 56 24954 75 28912 81 20845 66 16681 65 21455 75 30206 80 25702 67 22389 81 29362 77 29140 55 30394 81 3211578 25057 72 26608 85 31593 75 31915 68 27955 59 30318 57 22124 64 26491 76 30255 69 19739 57 18292 59 28517 61 33181 67 27387 56 30312 78 15311 54 26616 64

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Study Guide To Accompany Intermediate Accounting Volume 1

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield, Nicola M. Young, Irene M. Wiecek, Bruce J. McConomy

10th Canadian Edition

ISBN: 1118300866, 978-1118300862

More Books

Students also viewed these Accounting questions