In: Math
This dataset includes the number of work hours for each project, the function point count for each project, and identifiers for operating system, data management system, and programming language utilized.
Open the dataset pointworkload.csv in Excel. Create a new column that calculates the number of work hours per function point for each project.
FunctionPointCount | WorkHours | OS | DMS | Language |
1059 | 15000 | 1 | 5 | 1 |
234 | 1850 | 1 | 5 | 1 |
1533 | 13033 | 1 | 5 | 1 |
339 | 11742 | 1 | 2 | 1 |
205 | 283 | 1 | 5 | 3 |
420 | 17992 | 1 | 1 | 1 |
2618 | 36420 | 1 | 1 | 1 |
749 | 24700 | 1 | 2 | 4 |
126 | 1640 | 1 | 1 | 3 |
185 | 1491 | 1 | 5 | 4 |
713 | 6761 | 1 | 1 | 4 |
376 | 2495 | 1 | 5 | 1 |
724 | 3633 | 1 | 5 | 3 |
306 | 5000 | 1 | 2 | 3 |
315 | 2550 | 1 | 4 | 1 |
1734 | 4489 | 1 | 5 | 4 |
144 | 9657 | 1 | 1 | 1 |
881 | 19283 | 1 | 1 | 1 |
911 | 8206 | 1 | 1 | 1 |
600 | 14380 | 1 | 1 | 4 |
655 | 28993 | 1 | 1 | 1 |
2924 | 38608 | 1 | 1 | 1 |
1238 | 20815 | 1 | 1 | 4 |
3472 | 72219 | 1 | 1 | 1 |
119 | 3499 | 1 | 1 | 1 |
442 | 12096 | 1 | 1 | 4 |
452 | 11702 | 1 | 1 | 4 |
321 | 2735 | 1 | 5 | 1 |
805 | 14399 | 1 | 1 | 1 |
313 | 15819 | 1 | 1 | 4 |
202 | 5189 | 1 | 1 | 4 |
957 | 22420 | 1 | 1 | 4 |
426 | 7591 | 1 | 1 | 1 |
1105 | 15550 | 1 | 1 | 1 |
868 | 27800 | 1 | 2 | 3 |
1022 | 3684 | 1 | 1 | 4 |
390 | 10850 | 1 | 5 | 1 |
105 | 3415 | 1 | 2 | 1 |
746 | 18853 | 1 | 2 | 1 |
1491 | 38878 | 1 | 1 | 4 |
193 | 996 | 1 | 1 | 4 |
1815 | 19059 | 1 | 2 | 1 |
171 | 3800 | 1 | 2 | 1 |
719 | 26822 | 1 | 2 | 1 |
596 | 11402 | 1 | 2 | 1 |
695 | 8848 | 1 | 2 | 3 |
367 | 5091 | 1 | 1 | 1 |
301 | 2032 | 1 | 1 | 4 |
220 | 7958 | 1 | 2 | 4 |
369 | 3962 | 1 | 1 | 1 |
137 | 2407 | 1 | 1 | 1 |
146 | 2281 | 1 | 1 | 4 |
221 | 1628 | 1 | 1 | 4 |
672 | 4887 | 1 | 1 | 4 |
422 | 8260 | 1 | 1 | 1 |
121 | 638 | 1 | 5 | 3 |
318 | 5528 | 1 | 1 | 3 |
892 | 35555 | 1 | 2 | 4 |
181 | 2600 | 1 | 5 | 1 |
163 | 15508 | 1 | 1 | 1 |
653 | 1940 | 0 | 5 | 2 |
900 | 6163 | 0 | 5 | 2 |
172 | 2248 | 0 | 3 | 2 |
139 | 3153 | 0 | 3 | 2 |
549 | 7731 | 0 | 3 | 4 |
1339 | 10288 | 0 | 3 | 2 |
632 | 9857 | 0 | 1 | 2 |
999 | 13849 | 0 | 3 | 4 |
1137 | 18000 | 0 | 1 | 2 |
654 | 21819 | 0 | 5 | 1 |
342 | 2100 | 0 | 3 | 2 |
109 | 1264 | 0 | 5 | 2 |
360 | 3550 | 0 | 5 | 2 |
3290 | 50335 | 0 | 5 | 2 |
496 | 4884 | 0 | 4 | 1 |
389 | 2760 | 0 | 4 | 2 |
534 | 2000 | 0 | 3 | 4 |
1230 | 1393 | 0 | 3 | 4 |
268 | 4500 | 0 | 3 | 2 |
1190 | 25360 | 0 | 5 | 1 |
105 | 1400 | 0 | 3 | 4 |
328 | 3127 | 0 | 5 | 2 |
177 | 1558 | 0 | 3 | 2 |
273 | 6215 | 0 | 3 | 2 |
124 | 470 | 0 | 5 | 2 |
111 | 1086 | 0 | 5 | 2 |
355 | 980 | 0 | 5 | 2 |
321 | 1330 | 0 | 5 | 2 |
206 | 597 | 0 | 5 | 2 |
102 | 543 | 0 | 5 | 2 |
130 | 566 | 0 | 5 | 2 |
164 | 1840 | 0 | 3 | 2 |
278 | 1360 | 0 | 3 | 2 |
1391 | 31581 | 0 | 1 | 2 |
499 | 3998 | 0 | 3 | 2 |
195 | 2193 | 0 | 4 | 2 |
243 | 3940 | 0 | 3 | 4 |
145 | 2301 | 0 | 4 | 2 |
280 | 3288 | 0 | 4 | 2 |
362 | 6271 | 0 | 3 | 2 |
694 | 1474 | 0 | 3 | 4 |
212 | 2333 | 0 | 5 | 2 |
1325 | 14323 | 0 | 3 | 4 |
227 | 6578 | 0 | 3 | 2 |
Import the file you revised in Excel to include work hours per function point into SPSS
For calculating work hours per function point you have to take the ratio of work hours and function point count in excel.
Just go to another column and give the heading in first cell as work hours per function point and then in the next cell right the formula "=('Workhours cell number' / 'functionpointcount cell number')
For me the functionpointcount was in Column A and workhours in column B. So for me the formula will be "=(B2/A2)"
Then press enter so see the value in the first cell. After you get the value in first cell just take your mouse cursor to the corner of that cell and left click the mouse and scroll down upto the last value given. You will get the desired column.
To Import the file you revised in Excel to include work hours per function point into SPSS
In SPSS Click File > Open > Data. The Open Data window will appear.
In the Files of type list select Excel (*.xls, *.xlsx, *.xlsm) to specify that your data are in an Excel file. If you do not specify the type of file that you wish to open, your file will not appear in the list of available files. Locate and click on your file. The file name will appear in the File name field. Click Open.
If you are using SPSS Version 25, the Read Excel File window will appear.
In the Worksheet dropdown menu, select the sheet from your Excel workbook that contains your data.
Click OK when you are finished.
Alternatively, you can import Excel files into SPSS using syntax, instead of using the dropdown menus. The general syntax is:
GET DATA /TYPE=XLSX /FILE='C:\path\to\file.xlsx' /SHEET=name 'Name-of-Sheet' /CELLRANGE=full /READNAMES=on /ASSUMEDSTRWIDTH=32767. EXECUTE. DATASET NAME DataSetExcel WINDOW=FRONT.
Note: If you are importing an *.xlsx file, use /TYPE=XLSX. If you are reading an *.xls file, use /TYPE=XLS.