Exploring Advanced Data Analysis 1 | Page Challenge Yourself 8.4 Last Updated 4/9/18 Challenge Yourself 8.4 In this project, you will use scenarios and a scenario summary to analyze car purchasing options. The data for this project were downloaded from: https://www. fueleconomy. gov/feg/download. shtml You will use custom filtering to find the data you are interested in and copy it from this very large data set to another worksheet. You will then use Advanced Filter, conditional formatting, sorting, and subtotals to further analyze this subset of data. You will manipulate a PivotTable created from the main vehicle data set. Finally, you will use Solver to solve a business problem to help you pay for your new car. Skills needed to complete this project: • Creating What-If Analysis Scenarios • Creating Scenario Summary Reports • Creating a Custom Filter • Using Advanced Filter • Creating New Conditional Formatting Rules • Sorting Data on Multiple Criteria • Adding Subtotals • Changing the Look of a PivotTable • Filtering PivotTable Data • Activating the Solver Add-Inn • Using Solver 1. Open the start file EX2016-ChallengeYourself-8-4. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3. You want to purchase a new car. Your current car is worth $3,500 as a trade-in. The base sticker price on the car you want is $24,595. The first financing offer from the dealer is 1.9% APR for 24 months, with no cash back. The original financing offer terms are listed in cells A3:B9 on the Car Loan worksheet. Cell B10 contains a formula with a PMT function to calculate the monthly payment. Use what-if analysis tools to compare financing options. Create scenarios to compare financing options for the car loan. a. Create names for the following cells on the Car Loan worksheet to make the scenarios easier to follow: Name cell B3: Price Name cell B4: TradeIn Name cell B5: CashBack Name cell B6: Loan Name cell B8: Months Name cell B9: APR Name cell B10: Payment Name cell B12: TotalCost

Answers must be in the already filled Excel sheet provided

What is the most direct result of free trade supplying productive resources to areas where they're most needed? a. enhanced efficiency b. lower interest rates c. increasing specialization d. greater competition 2b2t

This problem has been solved! see the answerchapter 19 problem #8. quality and financial control (connect, perform)part one: geometrica designs and builds domes and space frames for large buildings. while the company had developed quality standards over time to respond to different client problems and training needs, it lacked a unified quality system, and its global client base wanted assurance that geometrica met an established international standard for quality. which of the following was an appropriate step for this company to take? a) reform its accounting and financial reporting systems to comply with sarbanes-oxleyb) establish and document a quality management system to comply with iso 9000management at workyou are the new fleet manager at xpressship, a package delivery company. as your first project, your boss has asked that you to look into implementing an electronic monitoring system for the fleet of 2,000 trucks your company owns. a recent internal audit on maintenance and repair costs on the company’s vehicles revealed while maintenance was performed regularly on the trucks, mileage or use had not been taken into account. this resulted in approximately $20,000 of unneeded repairs. you know that telematics have been used by other companies with fleets of cars or trucks and it will allow your company to not only track mileage and use, but also part replacement needs, vehicle oil pressure, and drivers’ speed and real time location. tracking these items can reduce maintenance costs while improving efficiency. you find that a simple computer can be installed in each vehicle. when the drivers return at the end of the day, the telematics information from each vehicle will be uploaded to a master computer where a software program will generate a report with results on the variables you have selected.early one morning as you are getting a cup of coffee, a few drivers that have been with the company for many years approach you with some concerns. eldon, the most senior driver says, “i heard you’re installing some type of computer to track our driving. my buddy works over at parcel and post package delivery and he said they’ve got these computers, too. he said managers are writing people up and firing drivers for speeding or not wearing seat belts. are you going to do that to us, too? ”part two: as a manager, which of the following statements would be effective in maintaining a positive relationship with company drivers? check all that apply.a) at this time, xpressship will be using telematics to monitor maintenance and repair needs, not drivers’ motoring habitsb) although the company isn’t doing so now, when xpressship begins to monitor driver motoring habits, the company will encourage them to keep a separate daily log where they can document any unusual circumstancesc) while xpressship could monitor things like speed, location, and idle time, the company trusts their drivers and will not be using that data in disciplinary decisionsd) xpressship executives are happy with their technology and believe that implementation is ideal for your organization

Which feature transfers a slide show into a word-processing document?