# business problem solving it s a excel works and some calculation question about 50mins works check the file for details question

Sheet 1

• On Sheet 1; using Goal Seek, what should be the actual value of Test 19 for the average score to be 98
• On Sheet 1, use Goal Seek to solve the simultaneous equation

Sheet 2

• Using Data Table complete the columns for:
• Using paragraphs, explain all the columns you just created in Sheet 2; and how can top managements make specific/general decisions using the values in the table (i.e. columns) you have created
• Using the columns you just created then draw any three charts/graphs with titles and label the charts/graphs appropriately. Also, make sure you use at least three paragraphs to explain each of the charts/graphs that you drewâ€¦be very general/specificâ€”how can top managements make decisions using your explanations/charts/graphs
• Create an eleventh column call (Faith) that ranked the column called â€œWeightâ€ in ascending order
• Create a twelfth column called LOVE and the formula to compute LOVE is:
• For each column compute the following: average, minimum value, maximum value, total value, median, mode, Standard deviation, and a function that count all value in each columns that are greater than the number fifteen
 Marketing Sales Revenue Total variable Cost Contribution Margin Total Fixed Costs Profit before Taxes

Note: Make sure the above column titles in the MS Excel file have the right and appropriate formula.

Sheet 3

Due Day:11.11