Question: A B C D E F G H K L M N O P Q Golden State 5k Location Los Angeles 20000 Year Participants Donations

A B C D E F G H K L M N O P Q Golden State 5k Location Los Angeles 20000 Year Participants Donations Intercept Slope RSQ Standard Error 2005 3000 $10,000.00 -9730.216652 6.616157006 0.968909038 2006 3750 $14,500.00 2007 4000 $17,000.00 Forecast High Low 2008 4500 $20,000.00 $122,592.92 Participant Forecast 2009 5000 $22,500.00 $100,000.00 2010 7500 $30,000.00 $90,000.00 y = 6.6162x - 9730.2 R2 = 0.9689 2011 8750 $45,000.00 $80,000.00 2012 9000 $50,100.00 $70,000.00 2013 9000 $56,000.00 $60,000.00 2014 9200 $58,250.00 $50,000.00 2015 10000 $60,125.00 $40,000.00 2016 10250 $62,500.00 $30,000.00 2017 11750 $64,000.00 520,000.00 2018 12250 $70,000.00 $10,000.00 2019 12500 $75,000.00 50.00 2020 15000 $85,500.00 0 2000 4000 6000 8000 10000 12000 14000 1600014 Enter a function in cell 16 to calculate the Standard Error. 7 Created On: 11/20/2020 Exp19_Excel_Ch08_Cap - Golden State 5K 1.1 Grader - Instructions Excel 2019 Project Points Step Instructions Possible 15 Use the FORECAST.LINEAR function in cell F9 to forecast potential donations once the goal 7 of 20,000 participants is reached. Format the results as Currency. 16 Complete your analysis by adding formulas in the range G9:H9 to calculate the high and low 8 thresholds of the forecast

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

hello, I need your help with these questions, please? - 3 0 The margin of error for a 95% interval estimate for the population slope parameter Is: I: 1.033 343 c 0.925 344 d 0.786 3'45 34.7 a -10.211...

In this mini-case, you need to audit and evaluate documents such as debt confirmations, vendor invoices, etc in theaudit of all of Apollo's liability accounts. For ease, your audit teammate has...

Please scroll from to bottom to the top A3 X V fx A B C D E F G H Compare State Spending on Education. Key for REGION is as follows: 1 = Northeast, 2 = Midwest, 3 = South, 4 = North Fiscal Year 2015...

WHAT IT SHOULD END UP LOOKING LIKE: EXCEL GIVEN BELOW: Exp19_Excel_Ch08_Cap_Golden_State_5K Project Description: You are a volunteer for the Golden State 5k, an annual 5k held across several cities...

Sager Company manufactures variations of its product, a technopress, in response to custom orders from its customers. On May 1, the company had no inventories of work in process or finished goods but...

hello, I need your help please with these questions? 53 369 96 54 244 64 55 164 38 56 57 1 The numerator of the slope coefficient formula for the estimated regression equation is: 58 ###### 59 ######...

I need your help please with these questions? - 3 0 The margin of error for a 95% interval estimate for the population slope parameter Is: I: 1.033 343 c 0.925 344 d 0.786 3'45 34.7 a -10.211 348 b...

Please Help!! Q6 V : XV fx A B C D E F G H J K L M N O These emails are NOT workpapers. Rather they are Date: 02 NOV 2020 14:37:42 +0000 useful communications for From: "Darlene Wardlaw" completing...

Excel File Edit View Insert Format Tools Data Window Help $ ? ) 53% [+ Wed 9:59 PM Q E ... AutoSave O OFF AHULENNOR - 1cost data_summer_2020_ - Saved to my Mac Home Insert Draw Page Layout Formulas...

\f\fB IUV MYAV iTHE MMA Excel BJX 3 ) BEERME. 29 B C D E F G H K L M N O P Q Concentration (mg/L) Peak Area 201 5214 14658 23647 100 32657 125 42652 150 52478 60000 150, 52478 50000 125, 42652 40000...

If a person rolls a pair of dice and gets a sum of 7 or 8, he wins 750. If the person gets a 6 or 9, he wins 500. The cost to play the game is 100. Find the expectation of the game.

4. (3 points) A store has 80 modems in its inventory, 30 coming from Source A and the remainder from Source B. Of the modems in inventory from Source A, 20% are defective. Of the modems in inventory...

Remember from our class discussion that it is useful to think of players who come to a game possessing different private information as different types When credible signaling works in the...

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...