Question
In: Statistics and Probability
Vol% R.I 0 1.3323 10 1.3388 20 1.3446 30 1.3497 40 1.3541 50 1.3580 60 1.3610...
| Vol% | R.I |
| 0 | 1.3323 |
| 10 | 1.3388 |
| 20 | 1.3446 |
| 30 | 1.3497 |
| 40 | 1.3541 |
| 50 | 1.3580 |
| 60 | 1.3610 |
| 70 | 1.3630 |
| 80 | 1.3638 |
| 90 | 1.3630 |
| 100 | 1.3600 |
I tried to graph the following data in excel to obtain the equation of the line which happens to be polynomial 4th order
I am given a R.I of 1.3616 and expected to obtain Vol% by solving the polynomial. i did that with excel and got 9.2 and the correct answer is around (you can guess by liner interpolation) is 63.
here's the polynomial : R.I= 1.3323+6.9476e(-4)X-4.711e(-6)X^2+3.7995e(-5)X^3-3.2634e(-10)X^4
can anyone do hand calculation and excel to confirm this
Solutions
Expert Solution
data
| R I | x | x^2 | x^3 | x^4 |
| 1.3323 | 0 | 0 | 0 | 0 |
| 1.3388 | 10 | 100 | 1000 | 10000 |
| 1.3446 | 20 | 400 | 8000 | 160000 |
| 1.3497 | 30 | 900 | 27000 | 810000 |
| 1.3541 | 40 | 1600 | 64000 | 2560000 |
| 1.358 | 50 | 2500 | 125000 | 6250000 |
| 1.361 | 60 | 3600 | 216000 | 12960000 |
| 1.363 | 70 | 4900 | 343000 | 24010000 |
| 1.3638 | 80 | 6400 | 512000 | 40960000 |
| 1.363 | 90 | 8100 | 729000 | 65610000 |
| 1.36 | 100 | 10000 | 1000000 | 1E+08 |
here x = vol
using excel
| SUMMARY OUTPUT | |||||
| Regression Statistics | |||||
| Multiple R | 0.999995918 | ||||
| R Square | 0.999991836 | ||||
| Adjusted R Square | 0.999986393 | ||||
| Standard Error | 3.98131E-05 | ||||
| Observations | 11 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | 4 | 0.001164867 | 0.000291217 | 183723.4853 | 2.17684E-15 |
| Residual | 6 | 9.51049E-09 | 1.58508E-09 | ||
| Total | 10 | 0.001164876 | |||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
| Intercept | 1.332288811 | 3.8106E-05 | 34962.69819 | 3.69551E-26 | 1.332195569 |
| x | 0.00069966 | 5.86868E-06 | 119.2192461 | 2.34825E-11 | 0.0006853 |
| x^2 | -4.93094E-06 | 2.5709E-07 | -19.17986044 | 1.29952E-06 | -5.56002E-06 |
| x^3 | 4.11616E-08 | 3.95622E-09 | 10.40426925 | 4.61841E-05 | 3.14811E-08 |
| x^4 | -3.40909E-10 | 1.96183E-11 | -17.37708938 | 2.32812E-06 | -3.88913E-10 |
RI ^= 1.332288811 + 0.00069966 x -4.93094 * 10^(-6) x^2 + 4.11616* 10^(-8)*x^3 -3.40909 * 10^(-10) x^4
solving
x = 62.4852
orchestra answered 1 year agoRelated Solutions
Given the data {20, 20, 30, 30, 40, 40, 50, 50, 60, 60}, calculate 1. Gini...
Given the data {20, 20, 30, 30, 40, 40, 50, 50, 60, 60},
calculate
1. Gini coefficient using the quintile distribution.
2. Draw the Lorenz curve with proper labels.
Consider a monopolist facing the following situation: Quantity 0 10 20 30 40 50 60 70...
Consider a monopolist facing the following situation:
Quantity
0
10
20
30
40
50
60
70
Price
$50
$45
$40
$35
$30
$25
$20
$15
Marginal Revenue
$40
$35
$25
$15
$2.5
$2.5
$15
Total Cost
$100
$370
$700
$960
$1120
$1225
$1650
$2250
Marginal Cost
$27
$35
$26
$16
$11
$43
$60
Average
Total Cost
$37
$35
$32
$28
$25
$28
$32
A. Graph the following:
Demand Curve
Marginal Revenue Curve
Marginal Cost Curve
Average Total Cost Curve
B....
Consider a monopolist facing the following situation: Quantity 0 10 20 30 40 50 60 70...
Consider a monopolist facing the following situation:
Quantity 0 10 20 30 40 50 60 70
Price $50 $45 $40 $35 $30 $25 $20 $15
Marginal Revenue $40 $35 $25 $15 $2.5 $2.5 $15
Total Cost $100 $370 $700 $960 $1120 $1225 $1650 $2250
Marginal Cost $27 $35 $26 $16 $11 $43 $60
Average Total Cost $37 $35 $32 $28 $25 $28 $32
A. Graph the following: Demand Curve Marginal Revenue Curve
Marginal Cost Curve Average Total Cost Curve
B....
Qd1 Qd2 P Qs1 Qs2 20 40 $10 80 60 30 50 $9 70 50 40...
Qd1 Qd2 P Qs1 Qs2
20 40 $10 80 60
30 50 $9 70 50
40 60 $8 60 40
50 70 $7 50 30
60 80 $6 40 20
18. Which supply and demand combination(s) result in a surplus
when the price is $8?_________________
19. Which supply and demand combination(s) result in a shortage
when the price is $8?_________________
20. Which supply and demand combination(s) result in an
equilibrium when the price is $8?_________________
Question 1 For the dataset: 20, 20, 10, 10, 40, 50, 20, 30, 10, 20, 50,...
Question 1
For the dataset: 20, 20, 10, 10, 40, 50, 20, 30, 10, 20, 50, 60,
20, 30, 50, 20, 30, 40, 30, 30, 30, 50, 40 calculate the max, min,
mode, median and mean.(20%)
Draw a boxplot with inner and outer fence
For the data in part (i), if the value 60 was replaced by 2000,
what would you call this value in the dataset? What could be the
explanation for such a value? How can you through...
Using the data set below: Score Frequency 20-30 5 30-40 8 40-50 13 50-60 12 60-70...
Using the data set below:
Score
Frequency
20-30
5
30-40
8
40-50
13
50-60
12
60-70
5
Draw a Histogram
Draw a polygon
After listening to YouTube “histogram and polygon,”
explain how histogram is different and similar to
polygon.
Calculate F Test for given 10, 20, 30, 40, 50 and 5,10,15, 20, 25. For 10,...
Calculate F Test for given 10, 20, 30, 40, 50 and 5,10,15, 20,
25.
For 10, 20, 30, 40, 50:
Classes (Percentage) No of Students 0 < 10 10 10 < 20 20 20 < 30...
Classes (Percentage)
No of Students
0 < 10
10
10 < 20
20
20 < 30
25
30 < 40
15
40 < 50
20
50 < 60
35
60 < 70
45
70 < 80
10
80 < 90
15
90 < 100
5
2.1 Determine the:
2.1.1 Mean number of marks (1 mark)
2.1.2 Median number of marks
2.1.3 Modal number of marks
2.2 Calculate the standard deviation
Cash=20 A/R = 10 merchandise=30 land =60 short-term investments=40 Current liabilities= 20. Find the current ratio....
Cash=20 A/R = 10
merchandise=30 land =60 short-term
investments=40
Current liabilities=
20. Find the current ratio.
Quick assets=50 A/P= 10 taxes
payable=10 long term bond payable=30
Find the quick ratio.
Inventory( Jan 1)=80 Inventory
(Dec 31)=60 COGS=280
Find inventory turnover
Inventory turnover=20 . Find days’ sales in inventory ( use 360
days)
Average assets= 100 sales
=70 , net income=8, gross profit=10. Find return on
assets.
Sales=300, gross profit=90, net income=60. Find return on
sales
Operating income=200, tax expense= 40,...
Price Quantity Supplied Quantity Demanded 8 50 20 7 40 25 6 30 30 5 20...
Price
Quantity Supplied
Quantity Demanded
8
50
20
7
40
25
6
30
30
5
20
35
4
10
40
Draw the supply curve and demand curve independently in a
separate graph.
Write the demand equation and the supply equation.
Combine both curves in one graph and show the equilibrium price
and quantity.
What is the quantity demanded when the price is $10?
Is there a shortage or surplus when the price equals
$8? What about $4?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A pension fund manager is considering three mutual funds. The first is a stock fund, the...
- Compute the cost of not taking the following cash discounts. (Use a 360-day year. Do not...
- During his project presentation, Bob falls sick and performs poorly. However, his colleague, Dan, concludes that...
- A sample human input file that contains test values that a human would enter on the...
- A solution is prepared by dissolving 15 ml of methanol in 150.0 ml water at 25...
- Consider a newlywed who is planning a wedding anniversary gift of a trip to Canada for...
- We are evaluating a project that costs $868,000, has a life of eight years, and has...
ADVERTISEMENT