Use R to load in the file “data.csv”. Assume that this is a random sample from some population with mean µ and variance σ 2 .
(a) Plot a histogram of the data.
(b) Compute a 95% confidence interval for the population mean µ using the formula
X ± (S/√ n)tn−1,.975.
(Hint: tn−1,.975 can be computed with qt(.975,df=n-1))
(c) Compute a p-value for the hypothesis H0 : µ = 5 versus HA : µ > 5, based on the test statistic T = X−5 S/√ n .
(Hint: The p-value can be computed using 1-pt(T,df=n-1))
(d) Based on the p-value, do we reject the null hypothesis at α = .01?
(e) What is the smallest significance level α for which we would reject the null?
Data set:
| x | |
| 1 | 4.698166 |
| 2 | 4.447565 |
| 3 | 6.841008 |
| 4 | 7.013583 |
| 5 | 3.129358 |
| 6 | 5.147627 |
| 7 | 2.549057 |
| 8 | 4.061032 |
| 9 | 2.482377 |
| 10 | 6.200452 |
| 11 | 3.017356 |
| 12 | 3.54399 |
| 13 | 5.02652 |
| 14 | 5.941181 |
| 15 | 7.012088 |
| 16 | 1.780168 |
| 17 | 4.338341 |
| 18 | 8.932189 |
| 19 | 8.437784 |
| 20 | 8.858227 |
| 21 | 4.750132 |
| 22 | 9.313738 |
| 23 | 4.09576 |
| 24 | 2.746881 |
| 25 | 3.80401 |
| 26 | 9.34906 |
| 27 | 5.87805 |
| 28 | 7.306379 |
| 29 | 7.147015 |
| 30 | 4.489627 |
| 31 | 5.048496 |
| 32 | 3.97515 |
| 33 | 5.325467 |
| 34 | 8.177696 |
| 35 | 6.422605 |
| 36 | 7.81162 |
| 37 | 9.849941 |
| 38 | 9.936086 |
| 39 | 8.045554 |
| 40 | 4.141212 |
| 41 | 5.19843 |
| 42 | 6.439768 |
| 43 | 5.067979 |
| 44 | 3.790223 |
| 45 | 8.642296 |
| 46 | 10.72038 |
| 47 | 5.450084 |
| 48 | 4.960262 |
| 49 | 3.355154 |
| 50 | 4.35933 |
In: Statistics and Probability
|
I need the formulas in excel: Thank you You're talking to a friend of yours who has student loans of $30,000. She has just graduated and now needs to pay them back with monthy payments at a 4.19% interest rate over the next 10 years. |
|||||||||
| a. Create a loan amortization table for this loan. | |||||||||
| b. If she increases her monthly payment by $100, how much sooner will she have paid off the loan? | |||||||||
| loan balance | |||||||||
| number of payments | |||||||||
| interest rate | |||||||||
| monthly payments | |||||||||
| Part a. | Part b. | ||||||||
| Month | Amount owed at beginning | Payment | Amount to Interest | Amount to principle | Amount owed at end | How much sooner will she pay off the loan? | |||
| 1 | |||||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 | |||||||||
| 8 | |||||||||
| 9 | |||||||||
| 10 | |||||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 | |||||||||
| 21 | |||||||||
| 22 | |||||||||
| 23 | |||||||||
| 24 | |||||||||
| 25 | |||||||||
| 26 | |||||||||
| 27 | |||||||||
| 28 | |||||||||
| 29 | |||||||||
| 30 | |||||||||
| 31 | |||||||||
| 32 | |||||||||
| 33 | |||||||||
| 34 | |||||||||
| 35 | |||||||||
| 36 | |||||||||
| 37 | |||||||||
| 38 | |||||||||
| 39 | |||||||||
| 40 | |||||||||
| 41 | |||||||||
| 42 | |||||||||
| 43 | |||||||||
| 44 | |||||||||
| 45 | |||||||||
| 46 | |||||||||
| 47 | |||||||||
| 48 | |||||||||
| 49 | |||||||||
| 50 | |||||||||
| 51 | |||||||||
| 52 | |||||||||
| 53 | |||||||||
| 54 | |||||||||
| 55 | |||||||||
| 56 | |||||||||
| 57 | |||||||||
| 58 | |||||||||
| 59 | |||||||||
| 60 | |||||||||
| 61 | |||||||||
| 62 | |||||||||
| 63 | |||||||||
| 64 | |||||||||
| 65 | |||||||||
| 66 | |||||||||
| 67 | |||||||||
| 68 | |||||||||
| 69 | |||||||||
| 70 | |||||||||
| 71 | |||||||||
| 72 | |||||||||
| 73 | |||||||||
| 74 | |||||||||
| 75 | |||||||||
| 76 | |||||||||
| 77 | |||||||||
| 78 | |||||||||
| 79 | |||||||||
| 80 | |||||||||
| 81 | |||||||||
| 82 | |||||||||
| 83 | |||||||||
| 84 | |||||||||
| 85 | |||||||||
| 86 | |||||||||
| 87 | |||||||||
| 88 | |||||||||
| 89 | |||||||||
| 90 | |||||||||
| 91 | |||||||||
| 92 | |||||||||
| 93 | |||||||||
| 94 | |||||||||
| 95 | |||||||||
| 96 | |||||||||
| 97 | |||||||||
| 98 | |||||||||
| 99 | |||||||||
| 100 | |||||||||
| 101 | |||||||||
| 102 | |||||||||
| 103 | |||||||||
| 104 | |||||||||
| 105 | |||||||||
| 106 | |||||||||
| 107 | |||||||||
| 108 | |||||||||
| 109 | |||||||||
| 110 | |||||||||
| 111 | |||||||||
| 112 | |||||||||
| 113 | |||||||||
| 114 | |||||||||
| 115 | |||||||||
| 116 | |||||||||
| 117 | |||||||||
| 118 | |||||||||
| 119 | |||||||||
| 120 | |||||||||
In: Finance
Using the accompanying Student Grades data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the model? If a student scores 70 on the midterm, what would you predict her grade on the final exam to be?
|
Student |
Midterm |
Final Exam |
|
|---|---|---|---|
|
1 |
7575 |
6464 |
|
|
2 |
8585 |
9090 |
|
|
3 |
8080 |
6969 |
|
|
4 |
8989 |
8484 |
|
|
5 |
7676 |
6161 |
|
|
6 |
6666 |
7878 |
|
|
7 |
7878 |
7272 |
|
|
8 |
9494 |
9494 |
|
|
9 |
6767 |
5959 |
|
|
10 |
9393 |
8686 |
|
|
11 |
7979 |
5353 |
|
|
12 |
8787 |
8484 |
|
|
13 |
8686 |
5555 |
|
|
14 |
6262 |
7373 |
|
|
15 |
9191 |
8686 |
|
|
16 |
7575 |
8888 |
|
|
17 |
6969 |
8181 |
|
|
18 |
9393 |
9595 |
|
|
19 |
7979 |
7878 |
|
|
20 |
6161 |
7070 |
|
|
21 |
6969 |
8383 |
|
|
22 |
7272 |
7373 |
|
|
23 |
6262 |
7474 |
|
|
24 |
6969 |
5555 |
|
|
25 |
7575 |
9494 |
|
|
26 |
7171 |
7878 |
|
|
27 |
9898 |
8989 |
|
|
28 |
5959 |
5353 |
|
|
29 |
8383 |
7777 |
|
|
30 |
7171 |
8181 |
|
|
31 |
7676 |
6969 |
|
|
32 |
9595 |
9797 |
|
|
33 |
7373 |
9292 |
|
|
34 |
7171 |
8080 |
|
|
35 |
7373 |
8282 |
|
|
36 |
9696 |
9595 |
|
|
37 |
7171 |
6262 |
|
|
38 |
9090 |
8383 |
|
|
39 |
9595 |
9696 |
|
|
40 |
8484 |
8888 |
|
|
41 |
6161 |
7373 |
|
|
42 |
6565 |
9393 |
|
|
43 |
9595 |
8383 |
|
|
44 |
8282 |
8888 |
|
|
45 |
8888 |
100100 |
|
|
46 |
9393 |
9696 |
|
|
47 |
7777 |
9191 |
|
|
48 |
8686 |
9393 |
|
|
49 |
9191 |
7878 |
|
|
50 |
7575 |
8383 |
|
|
51 |
9696 |
100100 |
|
|
52 |
7979 |
7272 |
|
|
53 |
6161 |
7878 |
|
|
54 |
6969 |
7676 |
|
|
55 |
8686 |
9191 |
|
|
56 |
8989 |
9494 |
|
|
Student |
Midterm |
Final Exam |
In: Statistics and Probability
The sale records of a retail store are given in the Excel worksheet "Retail"
| Week | Value |
| 1 | 10.37 |
| 2 | 5.90 |
| 3 | 8.70 |
| 4 | 6.80 |
| 5 | 7.00 |
| 6 | 9.87 |
| 7 | 10.95 |
| 8 | 10.77 |
| 9 | 11.15 |
| 10 | 8.85 |
| 11 | 13.22 |
| 12 | 6.02 |
| 13 | 6.55 |
| 14 | 9.12 |
| 15 | 11.77 |
| 16 | 10.05 |
| 17 | 10.72 |
| 18 | 9.40 |
| 19 | 9.07 |
| 20 | 12.82 |
| 21 | 4.92 |
| 22 | 10.95 |
| 23 | 13.92 |
| 24 | 15.62 |
| 25 | 6.65 |
| 26 | 13.77 |
| 27 | 8.77 |
| 28 | 9.70 |
| 29 | 8.40 |
| 30 | 10.35 |
| 31 | 8.65 |
| 32 | 6.30 |
| 33 | 6.40 |
| 34 | 9.45 |
| 35 | 9.77 |
| 36 | 5.42 |
| 37 | 10.67 |
| 38 | 7.32 |
| 39 | 7.20 |
| 40 | 7.05 |
| 41 | 9.97 |
| 42 | 7.72 |
| 43 | 10.87 |
| 44 | 7.47 |
| 45 | 13.05 |
| 46 | 9.40 |
| 47 | 12.07 |
| 48 | 10.40 |
| 49 | 6.12 |
| 50 | 12.87 |
| 51 | 12.05 |
| 52 | 12.10 |
| 53 | |
| 54 | |
| 55 |
1. Using the moving average method with p = 3 most recent data, the forecast value at time t = 53 is:
a/ 12.34
b/ 10.50
c/ 11.15
d/ 11.32
2. Using the moving average method with p = 3 most recent data, the M A P E is
a/ 9.52%
b/ 39.23%
c/ 26.92%
d/ 40.45%
3. Using the exponential smoothing with alpha = 4, the smoothed SALE at time t = 10 is
a/ 8.87
b/ 9.81
c/ 12.92
d/ 13.15
4. Using the exponential smoothing with alpha = 4, the forecasted SALE at time t = 53 is
a/ 11.49
b/ 14.50
c/ 11.05
d/ 15.53
5. The value of M A D for using exponential smoothing with alpha = 4 to forecast is
a/ 3.66
b/ 2.29
c/ 4.34
d/ 8.76
In: Statistics and Probability
Table 15.0
|
Base Year (2006) 2013 |
|||
|
Product |
Quantity |
Price |
Price |
|
Milk |
50 |
$1.20 |
$1.50 |
|
Bread |
100 |
1.00 |
1.10 |
In: Economics
John and Eric are childhood friends who went to school and university together. After graduation, John moved to Spain where he joined his family and started a business exporting authentic Spanish Artwork to clients around the World. Eric operates a retail store in Brazil, and the two friends agreed to start a business together. John would send artwork to Eric who would sell it in his store at a reasonable price. John shipped the Artwork by mail to ensure quick, timely delivery. Eric verbally agreed to pay John 30 days after shipment and they would split the profits equally, with each party getting 50 percent. 45 days after shipment, John contacted Eric to see how things were progressing. Eric informed John that the Artwork had not sold. He indicated some potential buyers had shown interest, but thought the art was priced too high. A month later, John called Erik to follow up and collect funds. Eric mentioned he had no cash on hand and his financial situation made it impossible to make any payments for the moment. Eric gave John the option to either take the frames back or sell them at cost. John is unable to obtain assistance from any of his friends and lawyers as there are no written contractual agreements signed. 4 months later, John followed up one last time. Eric mentioned he sold the frames for 25 percent of the asking price, and he did not transfer any funds for payment of artwork and additional costs. John lost $9,000 worth of goods and a friend that he trusted.
. What mistakes did John make during his negotiation
that led to this loss? *
2. Is there anything John can legally do now to minimize his loss in this transaction? *
3. How would you negotiate differently in a similar future transaction to avoid this situation at the end? *
In: Economics
When your company bought a new spectral analyzer, you arranged to pay for it with two payments:
You only paid $6,000 two months ago and you won’t be able to make your payment one month from now. You have arranged with the seller to settle your debt by making two equal payments:
Part A: How much will each of the equal payments be if the seller is charging 9% simple, with a focal date 4 months from today? (Your work must include a complete time-line diagram.)
Part B: How much extra interest will you have to pay for not making the originally planned payments?
In: Accounting
PLEASE ANSWER ALL QUESTIONS. Round to the fourth decimal place.
1). Two point charges, q₁= +10 nC and q₂= +1 nC, are located on the x-axis at x= 0 and x=5.00 m. What is the electric field at point x=1.80 m?
2). Two point charges, q₁= +7 nC and q₂= -5 nC, are located on the x-axis at x= 0 and x=5.00 m. What is the electric field at point x=3 m?
3).Two charges, one is + 30 nC and other is -2* 30 nC are separated by 1 m distance. What is the electric field at the mid point of the line joining the charges?
4).Two charges, one is - 34 nC and other is 2* 34 nC are separated by 2 m distance. What is the electric field at the mid point of the line joining the charges?
In: Physics
In: Computer Science
I have a question on an excercise from Cost Management, Blocher,, 7 ed. book.
You are currently trying to decide between two cost structures for your business: one that has a greater proportion of short-term fixed costs and another that is more heavily weighted to variable costs. Estimated revenue and cost data for each alternative are as follows:
|
Cost Structure |
||||||
| Alternative #1 | Alternative #2 | |||||
| Selling price per unit | $ | 50 | $ | 50 | ||
| Variable cost per unit | 35 | 30 | ||||
| Short-term fixed costs/year | 40,000 | 45,000 | ||||
| Required: |
| 1. |
What sales volume, in units, is needed for the total costs in each cost-structure alternative to be the same? 1000 |
| 2. |
Suppose your profit goal for the coming year is 10% of sales (i.e., operating profit ÷ sales = 10%). What sales level in units is needed under each alternative to achieve this goal? |
| 3. |
Suppose again that your profit goal for the coming year is 10% of sales. What sales volume in dollars is needed under each alternative to achieve this goal? |
In: Accounting