This dataset includes the number of work hours for each project, the function point count for...

60.1K

Verified Solution

Question

Basic Math

This dataset includes the number of work hours for each project,the function point count for each project, and identifiers foroperating system, data management system, and programming languageutilized.
Open the dataset pointworkload.csv in Excel.Create a new column that calculates the number of work hours perfunction 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 perfunction point into SPSS

Answer & Explanation Solved by verified expert

3.9 Ratings (731 Votes)

For calculating work hours per function point you have to takethe ratio of work hours and function point count in excelJust go to another column and give the heading in first cell aswork hours per function point and then in the next cell right theformula Workhours cell number functionpointcount cellnumberFor me the See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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