# Pt1420 Unit 3 Data Analysis Essay

Satisfactory Essays
434 Words
Grammar
Plagiarism
Writing
Score
Pt1420 Unit 3 Data Analysis Essay
Instructions

Copy the file name Motor Claims from the shared folder and paste it on a new work sheet. Carry out the following Analysis on the given data.

1. Frequency distribution analysis for Motor Claims with Veh Group and also with Driver’s Age.
2. Calculate Average, Standard Deviation, Minimum and Maximum values of Claims.
3. Perform Descriptive Analysis using the tool: Data Analysis for Claims Data.
4. Plot a claims distribution with claim size intervals of 10000, 20000, 30000, 50000, and 100000.

Comment on the analysis carried out.

Guidelines:

I. Claims Frequency analysis for Motor Claims:

1. Select the option “Data” from the menu and click Pivot table and Pivot chart wizard.

2. Select pivot chart with pivot
Select new worksheet and layout option. Then drag variable Vehgroup (small icon on the right) into row and Claims data into data column. Then double click Claims in the data column, select count function and click O.K.

5. Select the new worksheet option. Then Click finish button in the pivot table box.

II. Calculation of Claims Statistics (Average, Stdev., Min & Max values):

1. Type the given formula to calculate Average: =AVERAGE (A1:A1034).

2. Type . =STDEV(A1:A1034) to calculate standard deviation of claims

3. To find out Minimum and Maximum values of claims, type =MIN(A1:A1034) & =MAX(A1:A1034) on the data sheet..

III. Descriptive Analysis for motor claims:

1. Select the option “Tools” from the menu and select data analysis (in case data analysis function is not available – then you double click ‘Add-in’ option and select Analytical Tool Pak option, then you go to tools and select data analysis.

2. Select Descriptive analysis, then define cell range (A1:A1034) for the under the label “Input Range” for the variables (Claims) for which you want to perform descriptive analysis..

3. Select labels option and summary statistics.

4. Select output range and type the cell address, where you want to place the

## You May Also Find These Documents Helpful

• Good Essays

In the range B8:H16, create a two-variable data table. Set B3 as the row input cell, and B4 as the column input cell.…

• 566 Words
• 3 Pages
Good Essays
• Satisfactory Essays

Create a graph of your data for this part of the lab. You may use any graphing tool to create the graph, but be sure to follow common guidelines for creating a graph.…

• 353 Words
• 3 Pages
Satisfactory Essays
• Good Essays

5. In the Summary worksheet, in the range B5:F8, delete the existing values and insert formulas that add…

• 369 Words
• 2 Pages
Good Essays
• Satisfactory Essays

On sheet 3 of your Excel document, prepare a regression analysis based on the following FallSafe information from the…

• 336 Words
• 4 Pages
Satisfactory Essays
• Powerful Essays

* We are interested in a binomial experiment with 10 trials. First, we will make the probability of a success ¼. Use MINITAB to calculate the probabilities for this distribution. In column C1 enter the word ‘success’ as the variable name (in the shaded cell above row 1. Now in that same column, enter the numbers zero through ten to represent all possibilities for the number of successes. These numbers will end up in rows 1 through 11 in that first column. In column C2 enter the words ‘one fourth’ as the variable name. Pull up Calc > Probability Distributions > Binomial and select the radio button that corresponds to Probability. Enter 10 for the Number of trials: and enter 0.25 for the Event probability:. For the Input column: select ‘success’ and for the Optional storage: select ‘one fourth’. Click the button OK and the probabilities will be displayed in the Worksheet.…

• 813 Words
• 4 Pages
Powerful Essays
• Satisfactory Essays

You should download the Excel file “Data Download” and the Documentation (click on the pdf symbol). The documentation has a detailed explanation about how the different variables were collected and their significance.…

• 409 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

Present all relevant data in a data table below. Include an observations section for any…

• 428 Words
• 5 Pages
Satisfactory Essays
• Good Essays

c. 5 points: Using the built-in Excel function named COUNTIF, calculate the count (frequency) of…

• 1856 Words
• 7 Pages
Good Essays
• Satisfactory Essays

Use the data table’s information to solve the missing information is in Calculations and Results section. Make sure to use the right amount of significant figures.…

• 786 Words
• 4 Pages
Satisfactory Essays
• Powerful Essays

A PivotTable Report (commonly called a pivot table) is a specialized report in Microsoft Excel that summarizes and analyzes data from an outside source like a spreadsheet or similar table. That is, a pivot table is a tool for taking a large and complete amount of data and formatting it in a table that makes that same information easier to understand and assimilate. You generally will create a pivot table when you want to do one of the following: extract a smaller amount of data from a larger set of data sum up a large amount of data and compare one section of the original data with another or organize sub-categories of data within larger categories. It is important to organize an Excel spreadsheet properly, but especially so when you may want to create a pivot table from it. When creating a spreadsheet, remember the following advice: Label your data well. For example, the first row of an Excel spreadsheet should have clear, descriptive column labels. Verify that each spreadsheet column contains only one set of data. For example, a column labeled Fname should contain only the first names of salespersons or vendors or customers, etc, and a column labeled Total should sum up the same type of data from cell to cell. Keep your spreadsheet free of automatic subtotals. Pivot tables will calculate subtotals and totals for you. A PivotChart Report (commonly called a pivot chart) represents in graphical form the data from a pivot table. You can modify the layout and data from a pivot chart just as you can those of a pivot table. Finally, you can use the GETPIVOTDATA function in a worksheet to create a formula that will produce, under many conditions, a consistent answer even if you later rearrange the pivot table. Lesson Goal: Understand how to plan a pivot table. Create an Excel pivot table, change its summary function, and analyze three-dimensional data. Update a report and then…

• 10202 Words
• 41 Pages
Powerful Essays
• Good Essays

Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, comments, and explanation. Remove any extra sheets so your workbook is as compact as possible when you turn it in. Go back and review your labs for assistance in completing the different types of analysis.…

• 551 Words
• 3 Pages
Good Essays
• Good Essays

It was done in Minitab and results were put into Excel file to use in calculating standardized value of the residuals.…

• 913 Words
• 4 Pages
Good Essays
• Satisfactory Essays

D. Helga can slide cells to the four boxes or double-click properties to choose from a list of pivot table options.…

• 985 Words
• 5 Pages
Satisfactory Essays
• Good Essays

A. Data Table: Insert your Data Table here with your sample calculations. You must show at least one sample calculation per procedure step. (16 points)…

• 1069 Words
• 7 Pages
Good Essays
• Good Essays

Extensive detail and information is contained within the help function of Microsoft Excel and in the provided text.…

• 1877 Words
• 8 Pages
Good Essays