Walmart Revenue The annual revenue of Walmart is given in the table below (source). Walmart Annual...

Transcribed Image Text:

Walmart Revenue The annual revenue of Walmart is given in the table below (source). Walmart Annual Revenue (Billions of US dollars) 559.151 523.964 Year 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 514.405 500.343 485.873 482.130 485.651 476.294 468.651 446.509 421.849 408.085 404.254 377.023 348.368 312.101 284.310 Apply linear regression to the data in the table to find a model y = mx +b, where y is Walmart's annual revenue in billions of US dollars, and is the number of years since 2000. Use the model y = mz+ bwith m rounded to the nearest tenth and b rounded to the nearest hundredth to answer the questions 1-7 below. Question 1 Use the model found above to answer this question. What is the slope m? Round to the nearest tenth (1 decimal place). Question 2 Use the model found above to answer this question. What is the intercept b? Round to the nearest integer. Question 3 10 pts Use the model found above to answer this question. The value z = -7 should be used in the model to predict the revenue of Walmart in what year? 10 pts 10 pts Question 4 Use the model found above to answer this question. Select the words or phrases that give the interpretation of the slope of the regression line as a rate of change. The slope m is the rate of change of [Select] [Select] [Select] [Select] Question 5 V V V Since the slope is [Select] The units on the rate are Use the model found above to answer this question. What is the estimated revenue of Walmart in 2042? ✓with respect to [Select] billion US dollars. Round to the nearest billion US dollars. 10 pts , the revenue is V per 10 pts D Question 6 10 pts Use the model found above to answer this question. In what year will the estimated revenue of Walmart be 1,200 billion US dollars? Note: I am asking for the year, not the number of years since 2000. This may happen between two years. Round to the nearest year. Question 7 10 pts Use the model found above to answer this question. Using the revenue data for Jesaki Inc. for the past few years, we apply linear regression to the data to find a model y=57.1 z 1,175, where r is Jesaki's annual revenue in billions of US dollars, and t is the number of years since 2000. Use this model, together with the revenue model you found for Walmart to answer the question below. When will Jesaki's revenue overtake Walmart? Note: I am asking for the year, not the number of years since 2000. This may happen between two years. Round to the nearest year. D D Question 8 One employee of a computer store is paid a base salary of $1,016 a month plus a 6% commission on all sales over $5,022 during the month. How much must the employee sell in one month to earn a total of $3,180 for the month? Question 9 10 pts Question 10 10 pts A publisher for a promising new novel figures fixed costs at $37,638 and variable costs at $2.45 for each book produced. If the book is sold to the distributors for $11 each, how many books must be produced and sold for the publisher to break even? 10 pts A jazz concert brought in $164,477 on the sale of 8,926 tickets. If the tickets are sold for $10 and $20 dollars, how many of the $10 dollar ticket were sold? Walmart Revenue The annual revenue of Walmart is given in the table below (source). Walmart Annual Revenue (Billions of US dollars) 559.151 523.964 Year 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 514.405 500.343 485.873 482.130 485.651 476.294 468.651 446.509 421.849 408.085 404.254 377.023 348.368 312.101 284.310 Apply linear regression to the data in the table to find a model y = mx +b, where y is Walmart's annual revenue in billions of US dollars, and is the number of years since 2000. Use the model y = mz+ bwith m rounded to the nearest tenth and b rounded to the nearest hundredth to answer the questions 1-7 below. Question 1 Use the model found above to answer this question. What is the slope m? Round to the nearest tenth (1 decimal place). Question 2 Use the model found above to answer this question. What is the intercept b? Round to the nearest integer. Question 3 10 pts Use the model found above to answer this question. The value z = -7 should be used in the model to predict the revenue of Walmart in what year? 10 pts 10 pts Question 4 Use the model found above to answer this question. Select the words or phrases that give the interpretation of the slope of the regression line as a rate of change. The slope m is the rate of change of [Select] [Select] [Select] [Select] Question 5 V V V Since the slope is [Select] The units on the rate are Use the model found above to answer this question. What is the estimated revenue of Walmart in 2042? ✓with respect to [Select] billion US dollars. Round to the nearest billion US dollars. 10 pts , the revenue is V per 10 pts D Question 6 10 pts Use the model found above to answer this question. In what year will the estimated revenue of Walmart be 1,200 billion US dollars? Note: I am asking for the year, not the number of years since 2000. This may happen between two years. Round to the nearest year. Question 7 10 pts Use the model found above to answer this question. Using the revenue data for Jesaki Inc. for the past few years, we apply linear regression to the data to find a model y=57.1 z 1,175, where r is Jesaki's annual revenue in billions of US dollars, and t is the number of years since 2000. Use this model, together with the revenue model you found for Walmart to answer the question below. When will Jesaki's revenue overtake Walmart? Note: I am asking for the year, not the number of years since 2000. This may happen between two years. Round to the nearest year. D D Question 8 One employee of a computer store is paid a base salary of $1,016 a month plus a 6% commission on all sales over $5,022 during the month. How much must the employee sell in one month to earn a total of $3,180 for the month? Question 9 10 pts Question 10 10 pts A publisher for a promising new novel figures fixed costs at $37,638 and variable costs at $2.45 for each book produced. If the book is sold to the distributors for $11 each, how many books must be produced and sold for the publisher to break even? 10 pts A jazz concert brought in $164,477 on the sale of 8,926 tickets. If the tickets are sold for $10 and $20 dollars, how many of the $10 dollar ticket were sold?

Answer rating: 100% (QA)

To answer questions 1 through 7 we need to perform a linear regression analysis on the provided Walmart revenue data and use the linear equation model derived from that analysis The linear regression ... View the full answer