You will find a county with a population that grew from 2018 to 2019. You can...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You will find a county with a population that grew from 2018 to 2019. You can find county populations on the US Census Website. If for some reason you cannot download and open an Excel file you can see the data for Michigan counties in the attached document. You do not have to restrict yourself to Michigan, however. Sign up for your county in the "Project 1-County Claim" SignUpGenius so that no one else takes your county. (If you would like to use a county outside of Michigan, email me with subject: Math 131-Alternative County Selection and include the county in state in your request.) Each student must do a different county. If two papers have the same county, then I will grade the project from the person who selected the county on claim form and ask the other(s) to redo the project with a new county. What to do: 1. Create a spreadsheet file that shows what the population of the county would be each year if the population grew linearly from 2018 to 2038. Your spreadsheet should have two columns labeled Year and Population. The first column should have years from 2018 to 2038 listed. The second column should have the populations from 2018 and 2019 given by the US Census Bureau. The remaining cells should show populations from 2020 to 2038 if the population were to grow linearly at the same rate as it grew from 2018 to 2019. 2. Answer the following four questions. You may word process your answers or print neatly. The document you submit must be in PDF format, however. Most word processors allow you to save a document in PDF format. Printed answers can be scanned as a PDF using one of number of different apps, Directions to using one of them are included in the Week 1 Videos in HFC Online. In 2-3 sentences give the county and state you are using. Give the populations in 2018 and 2019. Tell how much the population grew from 2018 to 2019 Create an equation that models the table in your spreadsheet. Let y represent the population. Let x represent the number of years after 2018 (So, x = 3 would represent 2021, for instance). Give the answer in slope-intercept form. Write one or two sentences about how you found the model. Use your model to confirm the 2038 population in your spreadsheet table. Show your work. The US has an average of 2.8 hospital beds per 1000 people (American Hospital Association. 2020. Fast Facts On US. Hospitals, 20201 AHA. [online] [Accessed 9 August 2020]). Based on this and what your model predicts for the county's population in 2028, then how many hospital beds will the count need to have an average number? Explain how you found your answer. How many hospital beds will be needed in 2038? Explain. Both explanations should use complete sentences. Use mathematical notation when appropriate. 0.000011:50 DM You will find a county with a population that grew from 2018 to 2019. You can find county populations on the US Census Website. If for some reason you cannot download and open an Excel file you can see the data for Michigan counties in the attached document. You do not have to restrict yourself to Michigan, however. Sign up for your county in the "Project 1-County Claim" SignUpGenius so that no one else takes your county. (If you would like to use a county outside of Michigan, email me with subject: Math 131-Alternative County Selection and include the county in state in your request.) Each student must do a different county. If two papers have the same county, then I will grade the project from the person who selected the county on claim form and ask the other(s) to redo the project with a new county. What to do: 1. Create a spreadsheet file that shows what the population of the county would be each year if the population grew linearly from 2018 to 2038. Your spreadsheet should have two columns labeled Year and Population. The first column should have years from 2018 to 2038 listed. The second column should have the populations from 2018 and 2019 given by the US Census Bureau. The remaining cells should show populations from 2020 to 2038 if the population were to grow linearly at the same rate as it grew from 2018 to 2019. 2. Answer the following four questions. You may word process your answers or print neatly. The document you submit must be in PDF format, however. Most word processors allow you to save a document in PDF format. Printed answers can be scanned as a PDF using one of number of different apps, Directions to using one of them are included in the Week 1 Videos in HFC Online. In 2-3 sentences give the county and state you are using. Give the populations in 2018 and 2019. Tell how much the population grew from 2018 to 2019 Create an equation that models the table in your spreadsheet. Let y represent the population. Let x represent the number of years after 2018 (So, x = 3 would represent 2021, for instance). Give the answer in slope-intercept form. Write one or two sentences about how you found the model. Use your model to confirm the 2038 population in your spreadsheet table. Show your work. The US has an average of 2.8 hospital beds per 1000 people (American Hospital Association. 2020. Fast Facts On US. Hospitals, 20201 AHA. [online] [Accessed 9 August 2020]). Based on this and what your model predicts for the county's population in 2028, then how many hospital beds will the count need to have an average number? Explain how you found your answer. How many hospital beds will be needed in 2038? Explain. Both explanations should use complete sentences. Use mathematical notation when appropriate. 0.000011:50 DM
Expert Answer:
Answer rating: 100% (QA)
Answer 1 The county I am using is Oakland County Michigan The population in 2018 was 1237495 and in ... View the full answer
Related Book For
Financial and Managerial Accounting the basis for business decisions
ISBN: 978-0078111044
16th edition
Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello
Posted Date:
Students also viewed these accounting questions
-
Which of the following is NOT a source of capital for start-up businesses? a. Personal Savings b. Family and Friends c. Sales revenue O d. Bank Loans
-
In Appendix A, you will find a table titled 10-Year Summary of Financial and Operating Results for Home Depot. Review the various performance measures listed in the table. Choose at least one measure...
-
In Appendix A, you will find a table titled "Five-Year Summary of Financial and Operating Results" for Home Depot. Review the various performance measures listed in the table. Choose at least one...
-
A rectangular plate lying on the xy plane has sides 2 in the x direction and in the y direction, thickness h in direction z, and is made of a material with Young's modulus E, Poisson's ratio v, and...
-
Assume r = 8%, = 30%, = 0. In doing the following calculations, use a stock price range of $60-$140, stock price increments of $5, and two different times to expiration: 1 year and 1 day. Consider...
-
On Friday, December 8, Hometown Power Co.s board of directors declares a dividend of 75 cents per share payable on Wednesday, January 17, to shareholders of record as of Wednesday, January 3. When is...
-
The following questions deal with audits by public accounting firms. Select the best response for each question. a. Which of the following best describes why an independent auditor is asked to...
-
Assume Beatrice, Inc., uses three allocation bases to allocate overhead costs from departments to jobs: number of different parts, number of machine hours, and number of job setup hours. The...
-
Estimating Economic Damages Read Ch 10 and 12. Using the information provided in Ch 12 Exercise 31, answer the questions and prepare your estimate of economic damages as a result of the accident....
-
Suppose you take out a margin loan for $75,000. You pay a 6.4 percent effective rate. If you repay the loan in two months, how much interest will you pay?
-
Prove that there is a unique real number x such that for every real number y, xy + x - 17 = 17y.
-
What impacts do regulation and deregulation have on the economy, the markets, and you as an investor? What are some concrete examples of those impacts? Declare your position on this issue and provide...
-
Describe a general IoT-OS model, which consists of main features for an IoT-OS that can be used for a diverse set of applications.?
-
What are the three cycles of design science research explain them and give examples of each and how do they interact with design science research DSR?
-
What are the five major design areas Sun originally focused upon for the OS? 2- Who invented the first virtual hosting?
-
If ABC earned $8 per share with a retention or plowback ratio of 90%. Its initial growth rate is 30% and is expected to decline on a linear fashion until 10 years later when its growth will become...
-
SP 3 Serial Problem Business Solutions (Algo) LO P1, P2, P3, P4, P5 After the success of the company's first two months, Santana Rey continues to operate Business Solutions. The November 30, 2021,...
-
Should U.S. antidumping laws be stated in terms of average total costs or average variable costs?
-
Why are unfavorable variances recorded by using debit entries and favorable variances recorded by using credit entries?
-
The only transaction recorded in the plant assets account of Pompei Company in the current year was a $220,000 credit to the Land account. Assuming that this credit resulted from a cash transaction;...
-
Alberto & Sons, Inc., a retailer of antique figurines, engages in the following transactions during October of the current year: Oct. 1 Purchases 100 Hummels at $50 each. Oct. 5 Sells 50 of the...
-
What roles are played by the CICA, the CGAAC, and the SMAC for their members?
-
The following questions deal with audits by public accounting firms. Select the best response for each question. a. Which of the following best describes why an independent auditor is asked to...
-
Explain what is meant by determining the degree of correspondence between information and established criteria. What are the information and established criteria for the audit of Jones Ltd.'s tax...
Study smarter with the SolutionInn App