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
In: Math
Use the techniques of Chapter 4 to sketch the graph of y= x^4/4+x^3/3-x^2.
a) domain,
b) y-intercept,
c) asymptote(s),
d) intervals of increase and/or decrease,
e) local maximum(s) and/or local minimum(s),
f) intervals of concavity,
g) points of inflection. (For full credit, remember to show all work and include sign charts for the Increasing/Decreasing and 2nd Derivative tests.)
In: Math
Overall Instructions:
Prepare the report in good form as if you were submitting it to the financial vice-president of the company. It should be neat, well organized, and easy to follow. The standard is that anyone with accounting knowledge should be able to pick up your paper and quickly see what it accomplishes.
The spreadsheet should be programmed to make all calculations. For revisions, you should need only to type in the new information. Specific rules include:
Type each item of information only once.
Never embed information in formulas.
All information and solutions should be clearly labeled on excel.
Insole Vent Company purchased a building on January 1, 2026, paying $200,000 down and signing a mortgage note for an additional $3,400,000. The mortgage will be paid off with semi-annual payments (June 30 and December 31) over a period of 10 years. The mortgage rate is 4.5%.
Required:
Prepare the mortgage amortization schedule for the 10 years of this note.
Prepare the journal entries for the date of the sale and for the first two payments.
In a separate tab, repeat part A assuming the mortgage rate is 5%.
In a separate tab, repeat part A assuming the down payment of $500,000 and a mortgage of $5,000,000.
In: Accounting
*****In C++***** Exercise #3: Develop a program (name it AddMatrices) that adds two matrices. The matrices must of the same size. The program defines method Addition() that takes two two-dimensional arrays of integers and returns their addition as a two-dimensional array. The program main method defines two 3-by-3 arrays of type integer. The method prompts the user to initialize the arrays. Then it calls method Addition(). Finally, it prints out the array retuned by method Addition(). Document your code, and organize and space the outputs properly as shown below. Sample run 1: Matrix A: 2 1 2 7 1 8 3 20 3 Matrix B: 1 1 1 1 1 1 1 1 1 A + B: 3 2 3 8 2 9 4 21 4 Sample run 2: Matrix A: 2 2 2 2 2 2 2 2 2 Matrix B: 2 2 2 2 2 2 2 2 2 A + B: 4 4 4 4 4 4 4 4 4
In: Computer Science
Create a dice simulator in C#. The simulator must roll the dice 6 times and it must add the 3 highest rolls. So say it simulates: 4 4 5 2 1 3 the total would be 13 (4+4+5=13). Repeat this 6 different times.
So if the random dice simulator simulates the outcomes below it should output: 13, 13, 14, 12, 16, 12
1) 4 4 5 2 1 3
2) 2 3 6 1 3 4
3) 5 3 1 4 6 2
4) 4 2 2 1 1 6
5) 5 4 5 6 3 1
6) 1 2 4 5 3 2
In: Computer Science
Python Create Loop
1 = 1
1 + 2 = 3
1 + 2 + 3 = 6
1 + 2 + 3 + 4 = 10
1 + 2 + 3 + 4 + 5 = 15
Create a loop in python that makes this pattern
In: Computer Science
Realize signal processing systems described by the difference equation: ?1(?)=1/2 [?(?)+?(?−1)] and ?2(?)=1/2 [?(?)−?(?−1)] using Matlab. Assuming same input signal x(n)=sin(ωn) for various values of ω ={0,p/6 ,3p/2, 1.9p/2} applied to both systems find the following: a. Obtain stem plots and codes of y1(n) and y2(n) in each . b. Critically analyze y1(n) and y2(n) in terms of type of filter, maximum gain and cut off frequency. (Hint : The system can be tested by computing frequency response of the system).
In: Physics
The purpose of this assignment is to practice working with marketing research data, searching for patterns in the numbers that might lead you to a new understanding about consumers, their behaviors or their preferences. Download the McSandwich Excel spreadsheet that lists the responses given by 50 customers of the fast food restaurant. The customers were asked questions about the food (quality & variety), service (friendly, fast & competent), pricing, the overall experience (recommend to a friend, general satisfaction), and some personal information (gender, frequency of dining there, and how close to the restaurant they lived). Sort the responses by gender (0 = male, 1 = female) and use the “Average” function to determine if males and females had different opinions about the restaurant’s food, service, pricing and overall experience. Sort the responses again, this time by usage (0 = infrequent diner, 1 = frequent diner). Once again, use the “Average” function to determine if frequent diners and infrequent diners had different opinions about the restaurant’s food, service, pricing and overall experience. Sort the responses one last time, this time by home location (1 = less than a mile from the restaurant, 2 = 1-5 miles from the restaurant, 3 = more than 5 miles from the restaurant). Again, use the “Average” function to determine if nearby and more distant consumers had different opinions about the restaurant’s food, service, pricing and overall experience. In a 2 page document, summarize your conclusions from the three different ways you examined the data. Please include the specific numeric data that led you to those conclusions. Then, describe at least 3 recommended marketing actions for McSandwich, based on those conclusions.
| Customer ID number | Friendly Employees (1 = not at all friendly, 10 = very friendly) | Competitive Prices (1 = overpriced vs. competitors, 5 = a bargain vs. competitors) | Competent Employees (1 = not at all competent, 10 = very competent) | Quality of Food (1 = poor quality, 10 = high quality) | Variety of Food (1 = not enough variety on menu, 5 = too much variety on menu) | Speed of Service (1 = very slow, 10 = very fast) | Gender of Customer (0 = M, 1 = F) | How likely to Recommend Restaurant to a Friend (1 to 10, with 10 most likely) | Overall Satisfaction (1 to 10, with 10 most satisfied) | Frequency of visits (0 = infrequent diner, 1 = frequent diner) | Distance from Home to Restaurant (1 = less than a mile from the restaurant, 2 = 1-5 miles from the restaurant, 3 = more than 5 miles from the restaurant). |
| 1 | 4 | 1 | 5 | 5 | 2 | 5 | 0 | 3 | 4 | 0 | 1 |
| 2 | 3 | 5 | 6 | 6 | 3 | 8 | 1 | 5 | 5 | 1 | 2 |
| 3 | 6 | 1 | 10 | 8 | 5 | 5 | 0 | 6 | 7 | 1 | 3 |
| 4 | 5 | 2 | 10 | 7 | 5 | 8 | 0 | 5 | 6 | 1 | 3 |
| 5 | 6 | 2 | 9 | 5 | 3 | 8 | 0 | 6 | 5 | 1 | 2 |
| 6 | 2 | 2 | 9 | 5 | 3 | 6 | 0 | 3 | 4 | 0 | 1 |
| 7 | 3 | 1 | 8 | 4 | 1 | 7 | 1 | 4 | 4 | 0 | 1 |
| 8 | 5 | 1 | 10 | 7 | 3 | 7 | 0 | 5 | 6 | 1 | 3 |
| 9 | 3 | 4 | 6 | 5 | 3 | 6 | 0 | 4 | 4 | 0 | 1 |
| 10 | 5 | 1 | 10 | 6 | 4 | 7 | 0 | 5 | 6 | 1 | 3 |
| 11 | 3 | 1 | 9 | 4 | 2 | 6 | 0 | 4 | 5 | 1 | 1 |
| 12 | 3 | 4 | 9 | 7 | 3 | 8 | 0 | 6 | 5 | 1 | 2 |
| 13 | 5 | 1 | 9 | 5 | 3 | 4 | 0 | 5 | 5 | 1 | 2 |
| 14 | 2 | 2 | 7 | 5 | 3 | 7 | 1 | 4 | 4 | 0 | 1 |
| 15 | 4 | 3 | 10 | 4 | 2 | 5 | 0 | 5 | 5 | 1 | 2 |
| 16 | 3 | 3 | 6 | 5 | 3 | 8 | 1 | 4 | 3 | 0 | 1 |
| 17 | 5 | 2 | 9 | 6 | 2 | 5 | 0 | 6 | 6 | 1 | 3 |
| 18 | 2 | 1 | 8 | 3 | 1 | 6 | 1 | 4 | 4 | 0 | 1 |
| 19 | 4 | 4 | 6 | 6 | 3 | 9 | 1 | 4 | 5 | 1 | 2 |
| 20 | 1 | 2 | 7 | 5 | 3 | 9 | 1 | 3 | 4 | 0 | 1 |
| 21 | 2 | 3 | 6 | 5 | 3 | 8 | 1 | 4 | 4 | 0 | 1 |
| 22 | 5 | 2 | 9 | 5 | 1 | 6 | 0 | 5 | 6 | 1 | 3 |
| 23 | 2 | 3 | 7 | 4 | 2 | 9 | 1 | 4 | 3 | 0 | 1 |
| 24 | 3 | 2 | 10 | 5 | 3 | 4 | 0 | 6 | 5 | 1 | 2 |
| 25 | 6 | 1 | 9 | 5 | 2 | 7 | 0 | 7 | 5 | 1 | 2 |
| 26 | 4 | 1 | 8 | 6 | 3 | 5 | 0 | 4 | 5 | 1 | 2 |
| 27 | 5 | 4 | 6 | 6 | 3 | 9 | 1 | 5 | 6 | 1 | 2 |
| 28 | 4 | 1 | 9 | 3 | 2 | 6 | 0 | 4 | 4 | 0 | 1 |
| 29 | 5 | 4 | 7 | 7 | 4 | 10 | 1 | 6 | 6 | 1 | 3 |
| 30 | 4 | 2 | 8 | 5 | 3 | 4 | 0 | 5 | 6 | 1 | 2 |
| 31 | 3 | 2 | 10 | 5 | 3 | 4 | 0 | 5 | 5 | 1 | 2 |
| 32 | 4 | 1 | 9 | 6 | 3 | 7 | 0 | 5 | 5 | 1 | 2 |
| 33 | 1 | 2 | 7 | 5 | 3 | 10 | 1 | 4 | 3 | 0 | 1 |
| 34 | 4 | 3 | 9 | 6 | 4 | 7 | 0 | 6 | 6 | 1 | 3 |
| 35 | 5 | 2 | 9 | 4 | 2 | 5 | 0 | 6 | 4 | 0 | 1 |
| 36 | 4 | 5 | 6 | 6 | 3 | 8 | 1 | 5 | 5 | 1 | 2 |
| 37 | 4 | 2 | 10 | 5 | 2 | 5 | 0 | 5 | 5 | 1 | 2 |
| 38 | 3 | 2 | 7 | 7 | 3 | 8 | 1 | 4 | 4 | 0 | 1 |
| 39 | 4 | 1 | 8 | 6 | 3 | 5 | 0 | 4 | 5 | 1 | 2 |
| 40 | 1 | 2 | 7 | 5 | 3 | 10 | 1 | 4 | 3 | 0 | 1 |
| 41 | 6 | 2 | 9 | 4 | 2 | 5 | 0 | 6 | 5 | 1 | 1 |
| 42 | 2 | 3 | 6 | 6 | 4 | 8 | 1 | 4 | 4 | 0 | 1 |
| 43 | 3 | 3 | 9 | 6 | 3 | 7 | 1 | 5 | 6 | 1 | 2 |
| 44 | 2 | 3 | 8 | 6 | 3 | 7 | 1 | 5 | 6 | 1 | 2 |
| 45 | 3 | 1 | 7 | 6 | 3 | 8 | 1 | 3 | 4 | 0 | 1 |
| 46 | 3 | 3 | 8 | 7 | 4 | 8 | 0 | 5 | 4 | 0 | 1 |
| 47 | 3 | 4 | 5 | 8 | 4 | 6 | 0 | 4 | 5 | 1 | 2 |
| 48 | 4 | 1 | 7 | 5 | 2 | 5 | 0 | 3 | 4 | 0 | 1 |
| 49 | 5 | 1 | 9 | 5 | 3 | 7 | 0 | 6 | 5 | 1 | 2 |
| 50 | 3 | 2 | 7 | 7 | 3 | 8 | 1 | 4 | 4 | 0 | 1 |
In: Statistics and Probability
a+b+c=(abc)^(1/2) show that (a(b+c))^(1/2)+(b(c+a))^(1/2)+(c(a+b))^(1/2)>36
In: Advanced Math
Consider the two variables service quality and customer satisfaction. Service quality is independent variable and customer satisfaction is dependent variable. Perform regression analysis using SPSS and explain the results.
PLEASE USE SPSS ONLY AND PASTE THE OUTPUT OF SPSS. DO NOT USE EXCEL OR ANY OTHER SOFTWARE. SPSS ONLY PLEASE.
|
SERVICE QUALITY |
CUSTOMER SATISFACTION |
|
2 |
1 |
|
3 |
2 |
|
4 |
4 |
|
5 |
7 |
|
6 |
6 |
|
7 |
7 |
|
8 |
9 |
|
6 |
11 |
|
6 |
9 |
|
4 |
5 |
|
5 |
4 |
|
6 |
7 |
|
2 |
3 |
|
10 |
11 |
|
8 |
5 |
|
9 |
6 |
|
11 |
2 |
|
11 |
4 |
|
13 |
8 |
|
2 |
8 |
|
4 |
8 |
|
3 |
9 |
|
1 |
1 |
|
2 |
2 |
|
2 |
3 |
|
1 |
4 |
|
2 |
5 |
|
4 |
5 |
|
5 |
6 |
|
6 |
3 |
|
7 |
4 |
|
2 |
4 |
|
2 |
5 |
|
2 |
6 |
|
1 |
4 |
|
4 |
4 |
|
13 |
11 |
|
12 |
11 |
|
1 |
2 |
|
2 |
2 |
|
4 |
4 |
|
4 |
4 |
|
6 |
6 |
|
7 |
5 |
|
3 |
4 |
|
1 |
2 |
|
3 |
3 |
|
4 |
5 |
|
6 |
6 |
|
7 |
7 |
|
2 |
2 |
|
3 |
3 |
|
1 |
4 |
|
5 |
4 |
|
5 |
1 |
In: Operations Management