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

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

Solutions

Expert Solution

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.

milcah answered 9 months ago

Next > < Previous

Related Solutions

The dataset flatulence.xlsx includes the variables gender, the self-reported number of times per day the respondent...

The dataset flatulence.xlsx includes the variables gender, the self-reported number of times per day the respondent passes gas (perday), and the number of months the respondent claims to wait before passing gas in front of a romantic partner (howlong). Find the 95% confidence interval for the average number of times a person passes gas in a day. Find the 99% confidence interval for: the average number of months a female waits before passing gas in front of a romantic partner,...

Dataset The scikit-learn sklearn.datasets module includes some small datasets for experimentation. In this project we will...

Dataset The scikit-learn sklearn.datasets module includes some small datasets for experimentation. In this project we will use the Boston house prices dataset to try and predict the median value of a home given several features of its neighborhood. See the section on scikit-learn in Sergiy Kolesnikov’s blog article Datasets in Python to see how to load this dataset and examine it using pandas DataFrames. Reminder: while you will use scikit-learn to obtain the dataset, your linear regression implementation must use...

Use pd.crosstab() to count the number of regions of each cover type there are for each...

Use pd.crosstab() to count the number of regions of each cover type there are for each of the 40 soil types. Pass this function the Cover_Type column as its first argument and the Soil_Type column as the second argument. Store the results in a DataFrame named ct_by_st and then display this DataFrame. soil = np.unique(fc['Soil_Type']) palette = ['orchid', 'lightcoral', 'orange', 'gold', 'lightgreen', 'deepskyblue', 'cornflowerblue'] Perform the following steps in a single cell: 1. Start by converting the count information into...

I am trying to use the countif or countifs function to count the number of genres...

I am trying to use the countif or countifs function to count the number of genres used to describe a film and no matter what syntax I use, the result is 0. Can I use the countif(s) function to count columns? I want to count the number of movies that have 3 or more genre's associated with them. Here is a sample of the data I am working with: primarykey Movie Genre1 Genre2 Genre3 Genre4 Genre5 Genre6 Genre7 tt0499549 Avatar...

Main Objective: Create a function collect_statistics to count the number of words and mean length of...

Main Objective: Create a function collect_statistics to count the number of words and mean length of words in each sentence This is my code so far but I am struggling to join the two functions together. I would appreciate the help! The sentence given as an example is : "Haven't you eaten 8 oranges today?" the mean length of this sentence is 4.5 for reference. Each sentence needs to be split up if given multiple sentences, assuming each sentence ends...

Work is a a) point function b) path function c) depends on the state d) none...

Work is a a) point function b) path function c) depends on the state d) none of the mentioned

Suppose that workers are able to adjust the number of hours they work however they wish....

Suppose that workers are able to adjust the number of hours they work however they wish. If a tax is levied on wages and a worker does not change the number of hours she works, then which of the following statements is TRUE? The substitution effect exceeds the income effect OR the income effect exceeds the substitution effect? Will the income effect be equal to the substitution effect or we might not see any income effect? Thank you!

(1 point) A recent report for a regional airline reported that the mean number of hours...

(1 point) A recent report for a regional airline reported that the mean number of hours of flying time for its pilots is 66 hours per month. This mean was based on actual flying times for a sample of 49 pilots and the sample standard deviation was 8.5 hours. 2. Calculate a 99% confidence interval estimate of the population mean flying time for the pilots. Round your result to 4 decimal places. ( , ) 3.Using the information given, what is...

1. Suppose your average number of work hours per year has been 2000 hours with a...

1. Suppose your average number of work hours per year has been 2000 hours with a standard deviation of 118 hours. Please graph and calculate the probability you will work between 1900 hours and 2300 hours next year. Hint: Two Zs and be ready to add. Use the “old” Z formula for this problem. 2. Based on the information in Problem #1, please calculate the probability you will work between 2300 and 2500 hours next year. (again please use the...

Design and write a function to calculate a person’s pay for a variable number of hours...

Design and write a function to calculate a person’s pay for a variable number of hours worked. ● Create a constant called HOURLY_RATE set to 24.95 ● To Consider - should this be local to the function or global? ● Ask the user to enter their number of hours worked (do this inside the function). Remember to always use meaningful variable names for variables! ● Then calculate and return their total pay Add code to main which will call this...

Subjects