Question

In: Math

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.


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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT