| Company ID | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 1 | 5330 | 6352 | 6340 | 3399 | 6566 | 7376 | 6882 | 1842 | 7362 | 8205 | 6222 | 7695 | 1681 | 2283 |
| 2 | 7972 | 5941 | 2861 | 3290 | 1019 | 7399 | 6442 | 8003 | 5092 | 4634 | 7569 | 2538 | 2619 | 7932 |
| 3 | 8545 | 6667 | 2121 | 2339 | 4770 | 7296 | 3215 | 7919 | 2176 | 9129 | 1321 | 695 | 7945 | 1673 |
| 4 | 4578 | 466 | 4142 | 8350 | 7439 | 6085 | 8381 | 5872 | 2703 | 6974 | 702 | 5846 | 7176 | 9179 |
| 5 | 7302 | 2727 | 3103 | 7626 | 1587 | 152 | 1703 | 7555 | 7933 | 2909 | 6907 | 6706 | 3230 | 5961 |
| 6 | 1897 | 1004 | 2010 | 5347 | 7317 | 7296 | 4274 | 9668 | 933 | 464 | 5940 | 1800 | 7241 | 3500 |
| 7 | 9673 | 3027 | 8230 | 5254 | 2387 | 2204 | 3757 | 2198 | 4277 | 3363 | 1421 | 6232 | 7141 | 1058 |
| 8 | 5087 | 3357 | 4366 | 8394 | 1112 | 5339 | 7816 | 40 | 2661 | 2344 | 4169 | 9030 | 3342 | 6448 |
| 9 | 5231 | 2129 | 8041 | 3736 | 84 | 7751 | 7037 | 757 | 4196 | 6542 | 2284 | 8692 | 2194 | 9069 |
| 10 | 932 | 8292 | 6741 | 4472 | 8125 | 8098 | 1376 | 4459 | 609 | 4390 | 3383 | 7026 | 3724 | 1077 |
| 11 | 9339 | 1636 | 4046 | 8853 | 6472 | 3421 | 8477 | 421 | 5982 | 7183 | 937 | 6464 | 9546 | 120 |
| 12 | 2578 | 668 | 2880 | 1070 | 5176 | 2053 | 5537 | 7207 | 9743 | 5352 | 6070 | 3025 | 559 | 7095 |
| 13 | 7733 | 62 | 6281 | 6440 | 4685 | 5765 | 6021 | 6489 | 9301 | 7345 | 7595 | 8682 | 4337 | 6967 |
| 14 | 5129 | 7523 | 531 | 8214 | 7844 | 1324 | 1874 | 5539 | 2852 | 1405 | 1357 | 8172 | 3777 | 9676 |
| 15 | 3302 | 2895 | 3723 | 4878 | 8164 | 7557 | 622 | 8190 | 8919 | 104 | 9372 | 2238 | 7434 | 7909 |
| 16 | 8186 | 1823 | 9237 | 6659 | 5545 | 2644 | 6701 | 627 | 4053 | 5154 | 1397 | 9701 | 6229 | 6093 |
| 17 | 1289 | 7197 | 9180 | 6347 | 1669 | 8184 | 7139 | 3079 | 7598 | 264 | 1063 | 8523 | 390 | 1332 |
| 18 | 8992 | 1298 | 1372 | 2314 | 9826 | 9583 | 4291 | 4432 | 9447 | 7985 | 1622 | 9888 | 8798 | 1696 |
| 19 | 114 | 7637 | 9595 | 5612 | 9926 | 9296 | 8708 | 3297 | 8470 | 3881 | 2893 | 5397 | 9705 | 3073 |
| 20 | 2900 | 1997 | 7434 | 3348 | 909 | 593 | 5041 | 8253 | 7435 | 8234 | 4179 | 168 | 1196 | 4171 |
| 21 | 2484 | 7699 | 8177 | 7154 | 8270 | 9399 | 5589 | 4150 | 1434 | 559 | 1802 | 5397 | 9389 | 337 |
| 22 | 8956 | 8731 | 4600 | 190 | 3601 | 2678 | 9160 | 9896 | 6589 | 6981 | 8874 | 6861 | 3812 | 2602 |
| 23 | 5620 | 2361 | 9121 | 4453 | 5495 | 8411 | 6226 | 1594 | 2460 | 7285 | 8325 | 1706 | 8111 | 9610 |
| 24 | 2006 | 333 | 2785 | 3094 | 3338 | 4394 | 963 | 144 | 8169 | 3601 | 7283 | 8759 | 9617 | 4907 |
| 25 | 6763 | 8713 | 7986 | 5532 | 3823 | 7845 | 1235 | 3588 | 7295 | 7026 | 6889 | 838 | 5453 | 4245 |
| Question 1 | Identify the largest net income number | (Use Conditional Formatting for this question) | |||||||||
| For that cell, calculate: "Company ID"*100 + quarter | |||||||||||
| What is the value you get? | |||||||||||
| For example, if the largest net income belongs to "company ID": 3 and in quarter 5 | |||||||||||
| the number for your answer should be: 3*100 + 5 =305 | |||||||||||
| Question 2 | Identify the 3 smallest net income numbers. | (Use Conditional Formatting for this question) | |||||||||
| What is the sum these 3 numbers? | |||||||||||
| Question 3 | How many cells have net income more than 5000? | ||||||||||
| Question 4 | How many cells have net income less than or equal to 4600? | ||||||||||
| Question 5 | If net income in a given cell (firm/quarter) is less than 2000 OR more than 6000, give grade 1 for that cell | ||||||||||
| if not, give grade 3 | |||||||||||
| Find the total of the grade for all cells. | |||||||||||
| Question 6 | If net income in a given cell (firm/quarter) is more than 3000 AND less than 5000, give grade 1 for that cell. | ||||||||||
| If not, give grade 5 | |||||||||||
| Find the total of the grade for all cell. | |||||||||||
| Question 7 | Analyze the 1st quarter only. | ||||||||||
| Create a new column call "level1". | |||||||||||
| In this colum: | |||||||||||
| If net income of a company is less than 3000, then give value 2 | |||||||||||
| If net income of a company is more than or equal to 3000, then give value 3 | |||||||||||
| What is the total of the "level1" column? | |||||||||||
| Question 8 | Analyze the 1st quarter only. | ||||||||||
| Find the average net income for that quarter. | |||||||||||
| Create a new column call "level2". | |||||||||||
| In this colum: | |||||||||||
| If net income of a company is less than the above average, then give value 2 | |||||||||||
| If net income of a company is more than or equal to the above average, then give value 3 | |||||||||||
| What is the total of the "level2" column? | |||||||||||
| Question 9 | If net income in a given cell (firm/quarter) is more than 2000 and less than 4000, give grade 1 for that cell. | ||||||||||
| If not, give grade 5 | |||||||||||
| Sum the grade up and report the sum. | |||||||||||
| Question 10 | If net income in a given cell (firm/quarter) is less than 2500 OR more than 4500, give grade 1 for that cell | ||||||||||
| if not, give grade 3 | |||||||||||
| Sum the grade up and report the sum. | |||||||||||
| Question 11 | For each company, calculate the quarterly average for Net Income. | ||||||||||
| (so each company has 01 number of average, right) | |||||||||||
| For a give company/quarter (cell), if net income is greater than the above average, give value 3 | |||||||||||
| if not, give value 1. | |||||||||||
| So you now you have a big table with value 1 or 3. Now sum these number up and what is the value of that sum? | |||||||||||
| Question 12 | For each quarter calculate the average for Net Income across these companies | ||||||||||
| (so each quarter has 01 number of average, right) | |||||||||||
| For a give company/quarter (cell), if net income is greater than the above average, give value 3 | |||||||||||
| if not, give value 1. | |||||||||||
| So you now you have a big table with value 1 or 3. Now sum these number up and what is the value of that sum? | |||||||||||
In: Finance
Describing
1. Accounts receivable—
2. Note receivable—
3. Inventories—
4. Investments—
5. Prepaid expenses—
6. Land—
7. Equipment, net—
8. Patent—
9. Note payable—$
10. Interest payable—
11. Common stock—
In: Accounting
| Sample ID | Control | Nitrogen Treatment |
| 1 | 0.331 | 0.419 |
| 2 | 0.375 | 0.727 |
| 3 | 0.385 | 0.766 |
| 4 | 0.474 | 0.741 |
| 5 | 0.223 | 0.182 |
| 6 | 0.261 | 0.821 |
| 7 | 0.4 | 0.251 |
| 8 | 0.349 | 0.778 |
| 9 | 0.203 | 0.641 |
| 10 | 0.332 | 0.368 |
| 11 | 0.231 | 0.732 |
| 12 | 0.457 | 0.453 |
| 13 | 0.216 | 0.45 |
| 14 | 0.29 | 0.196 |
| 15 | 0.218 | 0.325 |
| 16 | 0.353 | 0.706 |
| 17 | 0.285 | 0.5 |
| 18 | 0.463 | 0.691 |
| 19 | 0.371 | 0.691 |
| 20 | 0.411 | 0.755 |
| 21 | 0.407 | 0.35 |
| 22 | 0.249 | 0.395 |
| 23 | 0.298 | 0.519 |
| 24 | 0.4 | 0.285 |
| 25 | 0.361 | 0.423 |
| 26 | 0.488 | 0.363 |
| 27 | 0.338 | 0.737 |
| 28 | 0.215 | 0.538 |
| 29 | 0.486 | 0.626 |
| 30 | 0.235 | 0.329 |
A soil scientist has just developed a new type of fertilizer and she wants to determine whether it helps carrots grow larger. She sets up several pots of soil and plants one carrot seed in each pot. Fertilizer is added to half the pots. All the pots are placed in a temperature-controlled greenhouse where they receive adequate light and equal amounts of water. After two months of growth, the scientist harvests the carrots and weighs them (in kilograms). Below is a data table showing the weight of the carrots at the end of the growing period from the two treatment groups. Here is a hyperlink to the data.
When analyzing this dataset with a t-test, the hypothesis states that the average size of the carrots from each treatment are the same, whereas the hypothesis states that the fertilized carrots are larger in size.
To analyze this data set, the scientist should use a -tailed t-test.
After performing a t-test assuming equal variances using the data analysis add-in for MS Excel, what is the calculated t-value for this data set?
Round your answer to four decimal places.
Your answer should be a positive value.
Report the appropriate critical t value, based on your decision of a one- or two-tailed test, calculated by MS Excel using the Data Analysis add-in.
Round your answer to four decimal places.
What is the appropriate p value for the t-test?
Report your answer in exponential notation
Report your answer to 4 decimal places after converting to exponential notation
e.g.
1.1234E-01 for 0.112341
3.1234E-04 for 0.000312341
Would you reject or fail to reject the null hypothesis?
In: Math
| Year | Sales |
| 1 | 424.50 |
| 2 | 432.00 |
| 3 | 504.00 |
| 4 | 582.00 |
| 5 | 609.00 |
| 6 | 618.00 |
| 7 | 624.00 |
| 8 | 652.50 |
| 9 | 642.00 |
| 10 | 652.50 |
| 11 | 693.00 |
| 12 | 678.00 |
| 13 | 711.00 |
| 14 | 714.00 |
| 15 | 745.50 |
| 16 | 730.50 |
| 17 | 784.50 |
| 18 | 792.00 |
| 19 | 798.00 |
| 20 | 828.00 |
1.Compute the two-period and four-period moving average predictions for the data set.
a. Prepare a line graph comparing the moving average predictions against the orig-inal data.
b. Do the moving averages tend to overestimate or underestimate the actual data? Why?
c. Compute forecasts for the next 2 years using the two-period and four-period moving average techniques.
2. Use regression analysis to fit a linear trend model to the data set.
a. What is the estimated regression function?
b. Interpret the R2 value for your model.
c. Prepare a line graph comparing the linear trend predictions against the original data.
d. What are the forecasts for the next 2 years using this technique?
In: Operations Management
Define the following key terms
1. Routing
2. Connectionless
3. Best-effort delivery
4. Maximum transmission unit (MTU)
5. Fragmentation
6. Internet Control Message Protocol (ICMP)
7. Network Address Translation (NAT)
8. Media independent
9. Loopback interface
10. Default gateway
In: Computer Science
| YR 0 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Yr 6 | Yr 7 | Yr 8 |
| (210,000,000) | 31,672,290 | 39,228,131 | 39,567,278 | 41,201,345 | 43,933,136 | 48,748,924 | 54,154,462 | 166,129,332 |
Calculate discounted payback. Please show steps
In: Finance
In: Psychology
|
Observation |
Price |
Dinners Sold |
|
1 |
$2.70 |
760 |
|
2 |
$3.50 |
510 |
|
3 |
$2.00 |
980 |
|
4 |
$4.20 |
250 |
|
5 |
$3.10 |
320 |
|
6 |
$4.05 |
480 |
Based on the reported historical data above, determine the following.
In: Operations Management
|
Year |
Stock X |
Stock Y |
|
1 |
12.00% |
10.00% |
|
2 |
4.00% |
18.00% |
|
3 |
15.00% |
2.00% |
|
4 |
1.00% |
8.00% |
What is the covariance of the returns of Stock X with the returns of Stock Y?
Please round to 6 decimal places.
In: Finance
find the k-th smallest value
given array[ 5, 2, 1, 15, 6, 9, 3, 4, 11] , k=2, the algorithm return the first two value: 1, 2
please show steps of how to output the first 2 values by using merge sort
and please analyze the running time.
your time is greatly appreciated.
In: Computer Science