Problems and Applications Using Excel

Problems and Applications Using Excel

Assignment 1.2: Problems and Applications Using Excel
Instructions
The purpose of this assignment is to use the skills and knowledge you have acquired so far and demonstrate that you have a firm grasp on all the topics that have been considered in Week 1. Please complete the following problems and submit them to the assignment drop-box by Day 7 of Week 1.
Chapter 1: Data and Business Decisions—Problems #4, #5, & #11.
Practice Problem: Chapter 1, Question 1.3
In the following video, I walk you through my process for solving question 1.3 from chapter 1.
Video Transcript
Problem 1.3 in Chapter 1 on page 27, construct a column chart for the data in the Excel file, state unemployment rates to allow comparison of the June rate with the historical highs and lows. We’re going to do that as a practice as you get ready to do your actual homework. All of the data files are posted in the link, so the Excel file state unemployment rate, when you open it, it looks like this. If you need a moment to pause the video and go get that file, you can do that now.
We’re going to build a column chart and a line chart associated with this. I’m going to click on “State, June 28, historical high and historical low,” and I’m going to hold my cursor down until I select everything in the table. Everything highlighted there. Now I’m going to go to Insert. I’m going to go to Recommended Charts because I think Excel will tell me the charts that maybe I want to do. I’m going to go to “All Charts” and I’m going to do a column chart. Here is my first chart. Now I can click on the “Chart Title” and change that to “State unemployment rates,” and so we’ve built a column chart.
Maybe now I want to evaluate the historical highs and historical lows better. I am going to, again, take the existing chart that I have. When I select it, all of the data’s selected. I’m going to do a shortcut here. I’m going to do “Control” “C” on my PC and then underneath it, I want to do “Control” “V.” I’ve got the exact same chart, so I did a cut and paste. If you’re on a Mac or you’re not comfortable with keyboard controls, you can also just highlight the exact field again and then go and build the same chart again. I’ve got my state unemployment rates, so I’m going to click on this top chart. In Chart Tools, I have a context-driven. I’m going to select outside my chart, I’m going to select an “E1” in my Chart Tools ribbon at the very top, the context-driven will disappear. Because the chart is no longer in context, the chart ribbon context goes away. If I select my chart, the chart tools context-driven appear, so I can click on “Chart Tools.” Now I’m going to say, “Change chart type.” I want to do a line chart, and then click “Okay.” Now I can see my historical highs and historical lows in comparison with the June 2008 rate. This might be a better metric, a better view for me to be doing comparisons against each state and their historical highs and lows.

Complete the assignment in one Excel sheet with a tab for each question. (Problems and Applications Using Excel)

Place an order with us on https://assignmentsproficient.com/order/  and expect the best grades and help from qualified writers

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"