Based on the Sporty Cars data, is "road test" a good predictor of Price at the 95% confidence level?
Select one: a. No, the R^2 statistic indicates that only 30% of the variability in price is explained by road test. b. No, the F-statistic indicates that the regression does not explain price significantly at the ninety five percent level. c. No, the t-statistic indicates that the coefficient on road test is not significantly different than zero at the 95% confidence level. d. All of the above are true.
How might the regression model be improved?
Select one:
a. Adding other explanatory variables such as years of age, miles and condition.
b. Adding data, including more observations for both price and road test score.
c. Both A and B could help improve model predictive accuracy.
d. Nothing can be done to improve regression accuracy; the results are final.
Background Information:
| Car | Price ($1000s) | Road-Test Score |
| Chevrolet Cobalt SS | 24.5 | 78 |
| Dodge Caliber SRT4 | 24.9 | 56 |
| Ford Mustang GT (V8) | 29 | 73 |
| Honda Civic Si | 21.7 | 78 |
| Mazda RX-8 | 31.3 | 86 |
| Mini Cooper S | 26.4 | 74 |
| Mitsubishi Lancer Evolution GSR | 38.1 | 83 |
| Nissan Sentra SE-R Spec V | 23.3 | 66 |
| Suburu Impreza WRX | 25.2 | 81 |
| Suburu Impreza WRX Sti | 37.6 | 89 |
| Volkswagen GTI | 24 | 83 |
| Volkswagen R32 | 33.6 | 83 |
Please show work in Excel
In: Statistics and Probability
The Department of Energy and the U.S. Environmental Protection Agency's 2012 Fuel Economy Guide provides fuel efficiency data for 2012 model year cars and trucks.† The file named CarMileage provides a portion of the data for 309 cars. The column labeled Size identifies the size of the car (Compact, Midsize, and Large) and the column labeled Hwy MPG shows the fuel efficiency rating for highway driving in terms of miles per gallon. Use α = 0.05 and test for any significant difference in the mean fuel efficiency rating for highway driving among the three sizes of cars. (Hint: you will need to re-organize the data to create indicator variables for the qualitative data).
State the null and alternative hypotheses.
H0: β1 =
β2 = 0
Ha: One or more of the parameters is not equal
to zero.
Find the value of the test statistic for the overall model. (Round your answer to two decimal places.)
Find the p-value for the overall model. (Round your answer to three decimal places.)
p-value =
please explain the process through excel
| Size | Hwy MPG |
| Compact | 30 |
| Compact | 31 |
| Compact | 31 |
| Compact | 33 |
| Compact | 29 |
| Compact | 31 |
| Compact | 27 |
| Midsize | 33 |
| Midsize | 34 |
| Midsize | 32 |
| Midsize | 30 |
| Midsize | 31 |
| Midsize |
30 |
| Large | 34 |
| Large | 34 |
| Large | 34 |
| Large | 35 |
| Large | 35 |
| Large | 28 |
| Large | 25 |
| Large | 25 |
| Large | 27 |
| Large | 27 |
| Large | 31 |
| Large | 27 |
In: Statistics and Probability
Loftus and Palmer (1974) demonstrated how the phrasing of questions regarding a perceived event could influence witnesses' memories of the event. In other words, memory is malleable depending on what and how we are asked to recall or describe a past event. The implication of this research is that people who witness a crime, an auto accident, or some other emotionally charged event can be led to certain conclusions about what they recall due to the specific questions asked by police or lawyers.
In a replication of this classic study, an investigator showed a film of two cars crashing into each other to a group of participants. Later, some participants were asked: "How fast were the cars going when they smashedinto each other?" A second group was asked: "How fast were the cars going when they bumpedinto each other?" A third group was asked: "How fast were the cars going when they contactedeach other?" Participants in each condition estimated (in miles per hour) the speed at which the vehicle was traveling. The results are presented in the table below.
|
Group 1 |
Group 2 |
Group 3 |
|
|
Verb |
"Smashed" |
"Bumped" |
"Contacted" |
|
30 |
20 |
10 |
|
|
25 |
16 |
14 |
|
|
22 |
18 |
12 |
|
|
27 |
18 |
10 |
A. Conduct a one-way analysis of variance on the above data (show your work).
B. Did the phrasing of questions about the event affect the participants’ recall? Based on these results, what can you conclude about the effect of question phrasing on recall of emotionally charged events? Given the context of this study explain the results in plain English
In: Statistics and Probability
6. Solve the following problems. Be sure to make a complete statement connecting the confidence interval to the population parameter or the sample size to the margin of error.
a) A study of 40 English composition professors showed that they spent, on average, 12.6 minutes correcting a student’s term paper. Find the 90% confidence interval of the mean time for all English professors when σ = 2.5 minutes.
b) A study of 36 marathon runners showed that they could run at an average rate of 7.8 miles per hour. The sample standard deviation is 0.6 mph. Find the 90% confidence interval for the mean of all runners.
c) A pizza shop wishes to find the 95% confidence interval of the true mean cost of a large plain pizza. How large should the sample be if she wishes to be accurate to within $0.15. A previous study showed that the standard deviation of the price was $0.26.
d) A survey of 50 first-time white-water canoers showed that 23 did not want to repeat the experience. Find the 98% confidence interval of the true proportion of canoers who did not wish to canoe the rapids a second time.
e) A recent study indicated that 29% of the 100 women over age 55 in the study were widows.
(i) How large a sample must one take to be 95% confident that the estimate is within 0.05 of the true proportion of women over age 55 who are widows? (ii) If no estimate of the sample proportion is available, how large should the sample be?
In: Statistics and Probability
Researchers have long suspected that texting has a detrimental effect on driving behavior. To avoid unnecessary high risk of driving on the roads, driving behavior is measured via driving simulator and the number of mistakes is recorded while texting and not texting as the person is driving the simulator. Mistakes such as failing to stay within the lane, driving at least 10 miles below or above the speed limit, and failing to use the turn signal are automatically recorded. To avoid individual differences in driving behavior, participants are tested twice: once under the “texting while driving” condition and once under the “driving without texting” condition. There are nine participants in the study. Their driving mistakes are reported in the table below.
Question: Do the data support the claim that texting has a detrimental (negative) effect on driving behavior, using an α = 0.05?
For this question, you must follow the steps of hypothesis testing and complete all your calculations by hand. Remember to show your calculations and provide your conclusions in sentence format.
Once you finish this part of the assignment, you can scan or take a photo of your work and paste the scan/photo in your Word document.
Table 1.
Number of mistakes by study participants while using the driving simulator
|
Participant |
Texting |
Not texting |
|
A |
35 |
21 |
|
B |
48 |
30 |
|
C |
25 |
10 |
|
D |
33 |
10 |
|
E |
30 |
11 |
|
F |
46 |
22 |
|
G |
37 |
16 |
|
H |
33 |
10 |
|
I |
37 |
23 |
In: Statistics and Probability
Variable Costing Income Statement for a Service Company
East Coast Railroad Company transports commodities among three routes (city-pairs): Atlanta/Baltimore, Baltimore/Pittsburgh, and Pittsburgh/Atlanta. Significant costs, their cost behavior, and activity rates for April are as follows:
| Cost | Amount | Cost Behavior | Activity Rate | |||
| Labor costs for loading and unloading railcars | $151,360 | Variable | $43.00 | per railcar | ||
| Fuel costs | 409,360 | Variable | 11.90 | per train-mile | ||
| Train crew labor costs | 199,520 | Variable | 5.80 | per train-mile | ||
| Switchyard labor costs | 114,400 | Variable | 32.50 | per railcar | ||
| Track and equipment depreciation | 183,700 | Fixed | ||||
| Maintenance | 122,400 | Fixed | ||||
Operating statistics from the management information system reveal the following for April:
| Atlanta/ Baltimore |
Baltimore/ Pittsburgh |
Pittsburgh/ Atlanta |
Total | |||||
| Number of train-miles | 12,080 | 9,520 | 12,800 | 34,400 | ||||
| Number of railcars | 380 | 2,010 | 1,130 | 3,520 | ||||
| Revenue per railcar | $704 | $268 | $452 | |||||
a. Prepare a contribution margin by route report for East Coast Railroad Company for the month of April. Calculate the contribution margin ratio, rounded to one decimal place.
| East Coast Railroad Company | ||||
| Contribution Margin by Route | ||||
| For the Month Ended April 30 | ||||
| Atlanta/Baltimore | Baltimore/Pittsburgh | Pittsburgh/Atlanta | Total | |
| Revenues | $ | $ | $ | $ |
| Variable costs: | ||||
| Labor costs for loading and unloading railcars | $ | $ | $ | $ |
| Fuel costs | ||||
| Train crew labor costs | ||||
| Switchyard labor costs | ||||
| Total variable costs | $ | $ | $ | $ |
| Contribution margin | $ | $ | $ | $ |
| Contribution margin ratio | ||||
In: Accounting
the 19th of April 2009, the Venezuelan Lechuza Carakas Polo team was due to appear in the semi-final of the US Open Polo Championship in Florida. The horses of the team were kept at the Lechuza Caracas equestrian facility near the polo grounds in Wellington, about 70 miles north of Miami. When the horses were offloaded from trailers at the polo club in the afternoon, staff discovered that some animals had died and the others were showing severe respiratory problems, incoordination and recumbency.
Even though veterinarians attending the polo event immediately rushed to provide emergency treatment to the animals, 20 of the 21 horses eventually died just prior to the event, during transport to the event, or soon after unloading at the event. One horse that had developed clinical signs was transported to a veterinary clinic but died later that evening.
Investigating the cause of death of the horses
If you had to lead the investigation into the death of these animals, what information would you try to gather or what type of tests would you conduct? What would you speculate could have happened
In: Biology
Case Scenario
Your favorite seventy-two-year-old Uncle Bob recently slipped on the ice and broke his left hip. After surgery and a four-day hospital stay, the hospital is ready to discharge him. His physician believes Uncle Bob would benefit from a stay at a skilled nursing facility where he would receive skilled nursing, physical therapy and occupational therapy. The physician writes the order. Your Uncle Bob has Medicare A and Medicare B.
Questions
1. Will Medicare cover his skilled nursing facility stay?Why or Why not? Be specific.
Because the social workers cannot recommend a facility, Uncle Bob asks you, the future healthcare administrator, for your advice. He wants to stay in within 10 miles of the State College area so family and friends can visit during his stay.
2. Using the data compiled in Nursing Home Compare (Links to an external site.)Links to an external site., which facility do you recommend and why?
Compare facility information to state and national standards, speaking specifically to (a) health inspections, (b) quality and (c) staffing in your response.
3. Based on your assessment of the facility data, is the Five-Star Quality Rating System helpful to potential residents and their families in making decisions about nursing home care?
Why or why not?
4. If a facility receives a five-star rating in one period and then is downgraded to a lower rating in a later period, does it face any financial consequences? Explain.
In: Nursing
-Fatima's records contain the following information:
1. Donated stock having a fair market value of $4,000 to a qualified charitable organization. She acquired the stock five months previously at a cost of $3,000.
2. Paid $900 to a church school as a requirement for the enrollment of her son.
3. Paid $350 for annual homeowner's association dues.
4. Drove 500 miles in his personal auto. The travel was directly related to volunteer services she performed for her church.
How much can Fatima deduct as a charitable contribution?
A) $2,456
B) $3,070
C) $3,356
D) $4,000
-GarLee Grocery, Inc., a C corporation with high taxable income, donates some of its inventory to the Local Food Bank (a charitable organization) which distributes food to the needy. At the time of the contribution, the FMV of the inventory was $20,000, and GarLee Grocery's basis was $6,000. Lee Grocery will be allowed a charitable contribution deduction of
A) $8,000.
B) $12,000.
C) $13,000.
D) $20,000.
-For non-cash charitable donations, an appraisal will be required for donations valued at more than
A) $250.
B) $500.
C) $5,000.
D) $50,000.
-Henry’s adjusted gross income is $50,000 in 2018. He donated a piece of artwork with a basis of $10,000 and a fair market value (FMV) of $25,000. He has owned the artwork for 10 years. The charity that Henry donated the artwork to is a public charity and will display the art work in its art center. What is the maximum charitable deduction in 2018 that Henry can take?
$0.
$10,000.
$15,000.
$25,000.
In: Accounting
you are working at a firm that conducts independent testing for heavy industry. Recently, an automobile manufacturer has been in the news for complaints about the highway gas mileage of their latest model minivan. You receive a contract from a consumer action group to test and write a report on the company’s claim that its minivans get 28 miles per gallon on the highway. The car company agrees to allow you to select randomly 35 low-mileage fleet minivans to test their highway mileage. Your test results gave you the following data:
29.7 24.5 27.1 29.8 29.2 27.0 27.8 24.1 29.3
25.9 26.2 24.5 32.8 26.8 27.8 24.0 23.6 29.2
26.5 27.7 27.1 23.7 24.1 27.2 25.9 26.7 27.8
27.3 27.6 22.8 25.3 26.6 26.4 27.1 26.1
List the null and alternative hypotheses for the two-tail test for the mean. Calculate the observed value of the test statistic and the associated p-value. (75–150 words, or 1–2 paragraphs)
List the null and alternative hypotheses for the one-tail test of the mean. Calculate the observed value of the test statistic and the associated p-value. (75–150 words, or 1–2 paragraphs)
In: Statistics and Probability