B $10 $20 500 $10,000 A 1 Input Data Model 2 Unit Cost 3 Unit Price 4 Demand 5 Annual Fixed Cost 6 7 Financial Spreadsheet 8 Variable Cost 9 Fixed Cost 10 Expenses 11 Revenue 12 Profit 13 $5,000 $10,000 $15,000 $10,000 -$5,000 14 15 16 17 18 19 20 21 22 $20.00 $22.00 $24.00 $26.00 $28.00 $30.00 $32.00 $34.00 $36.00 $38.00 $40.00 23 24 25 26 27 28 In the picture shown here, you are looking at a simple data model, and a small financial spreadsheet, which uses data from the Input Data model, to compute Profit in B12. You want to use Excel's one-way Data Table to compute the Profit, for the different Unit Prices shown ($20 to $40). Before you call the Excel's one-way Data Table, you know that you have to put the formula of Profit somewhere! To compute the profit in B17 to B27, where do you place the formula of Profit? A28 B16 A16 B15 B28 A15 Assume you are given the data shown below: Square Footage House Value 2000 $238,139.37 2200 $259,711.95 2400 $300,953.67 3000 $369,965.73 3200 $340,091.30 3600 $405,425.02 2900 $345,131.03 To see if there is a relationship between Square Footage and House Value, you decide to do a Scatter Plot in Excel, and add a Trend Line. You decide to display the Trend Line equation, and R Squared. Choose the statements that are TRUE, below: In the trendline equation, the coefficient of Square Footage represents how much House Value will increase by, when Square Footage increases by ONE square foot. If the x-axis goes from 2000 to a 2900, for the data that you have been given, you can use the trendline equation, with a very good level of confidence, to estimate the house value when x is 30,000 A trend line will show the relationship between two dependent variables The R Squared value is a measure of how good the fit of the trendline is