Create a Forecast Sheet that depicts year over year growth in customer growth. Set the Forecast end year as 2025 and place the results on a new worksheet named 2025Forecast. Ensure the Customers worksheet is active then create a scatter plot chart that places the Years on the X axis and the Clients on the Y axis. Add a linear trendline to the chart that also shows the Equation and the R-square. Add the title Customer Growth. Enter a function in cell E4 to calculate the intercept of the linear trendline created in the prior step. Enter a function in cell F4 to calculate the Slope of the linear trendline. Enter a function in cell G4 to calculate the R-square of the linear trendline. Enter a function in cell H4 to calculate the Standard Error. Use the FORECAST.LINEAR function in cell E7 to the total number of customers by the end of 2021.
Create a Forecast Sheet that depicts year over year growth in customer growth. Set the Forecast end year as 2025 and place the results on a new worksheet named 2025Forecast. Ensure the Customers worksheet is active then create a scatter plot chart that places the Years on the X axis and the Clients on the Y axis. Add a linear trendline to the chart that also shows the Equation and the R-square. Add the title Customer Growth. Enter a function in cell E4 to calculate the intercept of the linear trendline created in the prior step. Enter a function in cell F4 to calculate the Slope of the linear trendline. Enter a function in cell G4 to calculate the R-square of the linear trendline. Enter a function in cell H4 to calculate the Standard Error. Use the FORECAST.LINEAR function in cell E7 to the total number of customers by the end of 2021.
Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Chapter12: Working In The Enterprise: Systems, Certifications, And Careers
Section: Chapter Questions
Problem 10CT
Related questions
Question
100%
![NYC Office
Year
Clients
Intercept Slope
RSQ
Standard Error
Forecast Limit
1990
500
2022
1991
750
1992
1000
Forecast High
Low
1993
1050
1994
1125
1995
1210
1996
1300
1997
1500
1998
1550
1999
1580
2000
1600
2001
1730
2002
1800
2003
1930
2004
2000
2005
2015
2006
2035
2007
2045
2008
2075
2009
2150
2010
2225
2011
2400
2012
2450
Employee Satisfaction
Office_Data
Customers](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F28e2909e-59ae-4572-aed3-07960c54a16c%2F11268e17-d9ee-4432-bcd4-12be2f3aa964%2Fshm4uln_processed.jpeg&w=3840&q=75)
Transcribed Image Text:NYC Office
Year
Clients
Intercept Slope
RSQ
Standard Error
Forecast Limit
1990
500
2022
1991
750
1992
1000
Forecast High
Low
1993
1050
1994
1125
1995
1210
1996
1300
1997
1500
1998
1550
1999
1580
2000
1600
2001
1730
2002
1800
2003
1930
2004
2000
2005
2015
2006
2035
2007
2045
2008
2075
2009
2150
2010
2225
2011
2400
2012
2450
Employee Satisfaction
Office_Data
Customers
![Create a Forecast Sheet that depicts year over year growth in customer growth. Set the
Forecast end year as 2025 and place the results on a new worksheet named 2025Forecast.
Ensure the Customers worksheet is active then create a scatter plot chart that places the
Years on the X axis and the Clients on the Y axis. Add a linear trendline to the chart that also
shows the Equation and the R-square. Add the title Customer Growth.
Enter a function in cell E4 to calculate the intercept of the linear trendline created in the prior
step.
Enter a function in cell F4 to calculate the Slope of the linear trendline.
Enter a function in cell G4 to calculate the R-square of the linear trendline.
Enter a function in cell H4 to calculate the Standard Error.
Use the FORECAST.LINEAR function in cell E7 to the total number of customers by the end
of 2021.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F28e2909e-59ae-4572-aed3-07960c54a16c%2F11268e17-d9ee-4432-bcd4-12be2f3aa964%2Fi35dyd_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Create a Forecast Sheet that depicts year over year growth in customer growth. Set the
Forecast end year as 2025 and place the results on a new worksheet named 2025Forecast.
Ensure the Customers worksheet is active then create a scatter plot chart that places the
Years on the X axis and the Clients on the Y axis. Add a linear trendline to the chart that also
shows the Equation and the R-square. Add the title Customer Growth.
Enter a function in cell E4 to calculate the intercept of the linear trendline created in the prior
step.
Enter a function in cell F4 to calculate the Slope of the linear trendline.
Enter a function in cell G4 to calculate the R-square of the linear trendline.
Enter a function in cell H4 to calculate the Standard Error.
Use the FORECAST.LINEAR function in cell E7 to the total number of customers by the end
of 2021.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 12 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Enhanced Discovering Computers 2017 (Shelly Cashm…](https://www.bartleby.com/isbn_cover_images/9781305657458/9781305657458_smallCoverImage.gif)
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Enhanced Discovering Computers 2017 (Shelly Cashm…](https://www.bartleby.com/isbn_cover_images/9781305657458/9781305657458_smallCoverImage.gif)
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning