Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do i find the high and low of the forecast? =RSQ(04:C36,B4:B36) A B C D E F G H Intercept Slope RSQ Standard Error

image text in transcribed
How do i find the high and low of the forecast?
=RSQ(04:C36,B4:B36) A B C D E F G H Intercept Slope RSQ Standard Error -161881 81.73295 0.980535 4346.508074 Forecast Limit 2022 NYC Office Year Clients 1990 500 1991 750 1992 1000 1993 1050 1994 1125 1995 1210 Low Forecast High 3301.08 0 1 2 3 14 15 76 17 18 19 20 21 22 23 24 25 26 27 28 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 2013 2475 2014 2800 Employee Satisfaction Office_Data 2025Forecast Customers =RSQ(04:C36,B4:B36) A B C D E F G H Intercept Slope RSQ Standard Error -161881 81.73295 0.980535 4346.508074 Forecast Limit 2022 NYC Office Year Clients 1990 500 1991 750 1992 1000 1993 1050 1994 1125 1995 1210 Low Forecast High 3301.08 0 1 2 3 14 15 76 17 18 19 20 21 22 23 24 25 26 27 28 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 2013 2475 2014 2800 Employee Satisfaction Office_Data 2025Forecast Customers

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: 3

blur-text-image

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

Elementary Statistics In Social Research Essentials

Authors: Jack A. Levin, James Alan Fox

3rd Edition

0205638007, 978-0205638000

More Books

Students also viewed these Finance questions

Question

What do you need to know about motivation to solve these problems?

Answered: 1 week ago