The spreadsheet 6. You are given a spreadsheet that contains daily stock informa

Question

The spreadsheet 6. You are given a spreadsheet that contains daily stock information for a company. has the following information: Column A-Date Column B-Highest stock price for the day Column C·Lowest stock price for the day Column D-Closing stock price ·Column E·Volume of stock shares that were traded that day You attempt to create a Volume-High-Low-Close chart with the given data. However, the chart doesn't look like anything that was done in class. The chart below illustrates the result. a. Why did we encounter this problem when creating the Volume-High-Low-Close chart? (5 Points) b. How can we fix this problem? (5 Points)

Explanation / Answer

You encounter this problem because chart type is wrong. The data that should be provided to chart was improperly supllied. Wrong axis was choosen. To fix this problem follow the steps: Select the data bt only 4 cloumn not date column. Select column type chart Name the axis with proper scale,

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.