The manager of the police department wants to develop a forecast model for annua
ID: 3645384 • Letter: T
Question
The manager of the police department wants to develop a forecast model for annual maintenance on police cars, based on mileage in the past year and age of the cars. Consider the following data:Miles Driven Car age (year) Maintenance cost
--------------- ----------------- ---------------
16,320 7 $1,200
15,100 8 1,400
18,500 8 1,820
10,200 3 900
9,175 3 650
12,770 7 1,150
8,600 2 875
7,900 3 900
a. Using Excel, develop a multiple regression equation for these data.
b. Forecast the annual maintenance cost for a police car that is 5 years old and will be driven 10,000 miles in 1 year.
Explanation / Answer
Parts of the Excel Screen This tutorial identifies the main parts of the Excel spreadsheet work area. There are links from each label to glossary items describing each part in greater detail. Excel Math If you are looking for tutorials on how to add, subtract, multiply, or divide numbers in Excel, these tutorials will show you how to do it. Each tutorial includes a step by step example on how to create a formula that will carry out one of the four basic math operations in Excel. Entering Data in Excel This tutorial covers the basics of how to enter data into an Excel spreadsheet. Items such as the importance of planning your spreadsheet before you enter data, widening columns, the types of data that can be entered, and editing cells to change data, are covered in this tutorial. Basic Excel Spreadsheet Tutorial The tutorial covers the basics of creating a spreadsheet in the latest versions of Excel. Topics covered include entering data, creating simple formulas, and formatting a worksheet. Working with Data, Formulas, and Functions Step by Step Tutorial Formulas, and functions are two of the most frequently used features in Excel. This tutorial covers using formulas and functions in more detail than the basic tutorial listed above. The tutorial includes step by step examples to show you how to create and use a variety of formulas and functions in Excel. Formatting a Worksheet in Excel Formatting is a big part of completing a worksheet. This tutorial covers applying such formatting features as: shading alternate rows of data adding currency and percent symbols widening columns changing data alignment A Guide to Creating and Formatting Excel Charts A graph, or a chart as it is known in Microsoft Excel, is a visual representation of worksheet data. A chart often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see. This list of step by step tutorials covers how to create the most commonly used charts in Excel - column chart (bar graph) pie chart, line graph, and even how to use the Sparklines - which are new to Excel 2010. Printing in Excel Use the print options in Excel to print entire spreadsheets or just selected areas. You can also choose to change the worksheet's orientation before you print or adjust the size of your printout so that it fits on one page. Excel's SUM Function Step by Step Tutorial Since adding rows and columns of numbers is one of the most common operations in Excel, Microsoft has included a shortcut to make the job easier. This step by step tutorial walks through how to use Excel's SUM function. Add / Delete Columns and Rows It’s a rare occasion when a spreadsheet doesn’t need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows. How to Use the Excel's Date Function There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers the most commonly used date functions used in Excel. How to Widen Columns in Excel Widening columns in Excel is one of the most commonly performed operations. This article will show you how to carry out this task easily.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.