Question: A B D E F 1 M N G H 1-way data table Price 3 Profit Price Fixed cost Unit cost Quantity Value 18 500

 A B D E F 1 M N G H 1-way

A B D E F 1 M N G H 1-way data table Price 3 Profit Price Fixed cost Unit cost Quantity Value 18 500 16 110 5 6 7 9 1760 PROBLEM Create a one way data table in the range H2:N3, using the Row Input values 0,5,10,15,20 and 25 The result should display values for profit in cells 13:N3, where the value in the cell forrow of each column is the profit achieved when price is set at thevalue in the cell for row 2 of that column. Hint: Enter the row Input values through 25 in cells 12:N2 Enter the formula"-12" in cell H3 2260 Variable cost Total cost Revenue Profit 10 11 12 13 1980 -280 To create the data table, select the range H2:N3, then select Data from the menu, then What If Analysis, and then Data Table. and when the box pops up asking for the Row Input cell and Column input cell, enter enters for the Row Input cell, leave the column input cell blank, and click OK 14 15 16 17 18 19 20 21

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 Databases Questions!