Create a scatterplot using the data provided

Assignment Help Operation Management

Reference no: EM133675029

Assignment

Sheet I

1. Type your Farid Faraj in cell A1.
2. Type "UNV-504" in cell A2.
3. Type "Topic Excel Assignment" in cell A3.
4. Double click Sheet I in the bottom left corner and rename Sheet I as "Title Sheet."

Sheet II

(Review "Excel Formulas and Functions Tutorial," located in the topic Resources.)

1. Open Sheet 2 by clicking the Sheet II tab at the bottom of the Excel Workbook.

2. In cell D1, type "Total Unit Sales."

3. Using the basic calculation functionality of Excel, find the total unit sales (Price per Unit times the Units Sold) for each product. Do not use a separate calculator to find the results. Include the result in column D.

4. Type "Average" in cell A12.

5. In cell B12, insert a function to find the average price per unit.

6. In cell C12, insert a function to find the average number of units sold.

7. Change the price per unit of weed spray to $26.06.

8. Change the plastic buckets units sold to 359.

9. Type Total Sales in cell F4.

10. Insert a function in cell G4 for the sum of all Total Unit Sales.

11. Rename Sheet II "Garden Store."

Sheet III

(Review "How to Create a Pie Chart in Excel (With Percentages)," located in the topic Resources.)

1. Create a pie chart using the data in columns D and E.
2. Add data labels so that each slice of the pie shows the corresponding percentage and instrument family.
3. Rename Sheet III "Symphony."

Sheet IV

(Review "How to Make a Line Graph on Excel," located in the topic Resources.)

1. Create a line graph for Northeast Sales and Southeast Sales using the data provided.
2. Create a second line graph for Northwest Sales and Southwest Sales using the data provided.
3. Rename Sheet IV "Division Sales."

Sheet V

(Review "How to Make a Scatter Graph/Plot in Microsoft Excel (Scatter Graph Tutorial)," located in the topic Resources.)

1. Create a scatterplot using the data provided.
2. Label the X-Axis "Attendance" and the Y-Axis "Soft Drink Sold."
3. Label Sheet V "Drinks."

Sheet VI

(Review "How to Rename a Worksheet in Microsoft Excel," located in the topic Resources.)

1. Create a new tab.
2. In cell A1, type the most challenging part of this assignment.
3. In cell A2, write something new that you learned.
4. Label Sheet VI "Last."

Reference no: EM133675029

Questions Cloud

Evaluate the reasoning of the author of the selected article : Address all eight criteria to evaluate the reasoning of the author(s) of the selected article. Write in paragraphs. Do not use a numbered list.

Competence in leveraging informatics knowledge : Explain how competence in leveraging informatics knowledge to enhance the quality and safety of patient care

Describe an experiential learning experience : Describe an experiential learning experience. Examine the experience from personal, academic, and civic engagement perspectives.

Proposed capstone project : Discuss the setting or context in which the problem or issue can be observed and describe the population affected by this problem or issue.

Create a scatterplot using the data provided : Create a scatterplot using the data provided. Label the X-Axis Attendance and the Y-Axis Soft Drink Sold. Label Sheet 5 Drinks.

Currently stationed in Fort Cavazos : What to write in response to someone is currently stationed in Fort Cavazos, still learning about the area

How would you graphically identify erm components : How would you graphically identify each of the following ERM components in a Crow's Foot notation with example - Discuss the difference between a composite key

Conventional and complementary practitioners : In an Essay describe the differences between conventional and complementary practitioners.

How would you define the term informatics : How would you define the term informatics as it relates to healthcare?

User Account

All Pages