***PLEASE IGNORE SAMPLE CHART IN THE INSTRUCTIONS**** Need in excel question 2 a

Question

***PLEASE IGNORE SAMPLE CHART IN THE INSTRUCTIONS****

Need in excel question 2 and 3. Please, give answer in a sharable excel link from a google drive or edit my link with answers.

Crimedata.xlsx file link: https://docs.google.com/spreadsheets/d/1eI6CDnvQDAXyRlUU4ZzJZ6zpAYsyJ8242F5dIjdtHzU/edit?usp=sharing

Dow.xlsx file link: https://docs.google.com/spreadsheets/d/1jILCa7i_2fY3fEOr0F0na7QdKMpGzMVEerEioir6YkY/edit?usp=sharing

Question 2: The Dow.xlsx data contains the values of the Dow Jones Index for January 2 through August 10, 2010. Create a line sparkline to show the ups and downs of the market. Then, below the line sparkline, use a win/loss sparkline to show the ups and downs of the market. Please make the cells displaying the sparklines wide enough see what is going on. Comment on what the different views of the same data highlights for you. Question 3: The Crimedata.xlsx file contains annual violent crimes, property crimes and murders in the United States. Using the concepts from Chapter 52 in the Winston text and this data, create a graph showing the number of crimes each year. Use check boxes to control which series are plotted. Your graph should look something like the one attached

Explanation / Answer

Excel files are in below URL. Uploaded them with the same file names.

http://www.rapidshare.com.cn/NqnTJpw

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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