File: The file Corruption.xls contains country-level data on two variables. One of these is a measure of
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The file Corruption.xls contains country-level data on two variables. One of these is a measure of perceptions of political corruption. (This data is assembled by the organization Transparency.org.) [NOTE: I have modified the original corruption measure so that higher values mean higher corruption. The least corruption possible has a measure of 0, the highest a measure of 10.] The second variable is a measure of GDP per capita. a) (10) Before looking at any data, propose a simple economic story (model) for how these two variables might be related. Write a paragraph of no less than 50 words in which you explain your argument. Which is the independent, and which is the dependent variable in your model? (Plausible stories could be told in which either variable could be the independent (or dependent) variable.) b) (10) Whichever way you've chosen to model this problem, execute a linear regression. For one time in your life, you are going to be calculating the slope and intercept estimators in EXCEL (or Google Spreadsheet) using the "by hand" method that was demonstrated in the lectures. DO NOT USE THE BUILT IN EXCEL REGRESSION/VARIANCE/COVARIANCE FEATURES (except to check your work, if you desire). Report your Betahats. c) (10) What percentage of the variation of your dependent variable is explained by the independent? d) (10) Also "by hand," calculate the variance of B. Next, calculate the test statistic and p- value for a hypothesis test that the population slope is zero. (The p-value is going to be extremely small and not be on any t-table. Figure out how you can use Excel to calculate it. (Look up the t.dist functionality in the help menus.) The file Corruption.xls contains country-level data on two variables. One of these is a measure of perceptions of political corruption. (This data is assembled by the organization Transparency.org.) [NOTE: I have modified the original corruption measure so that higher values mean higher corruption. The least corruption possible has a measure of 0, the highest a measure of 10.] The second variable is a measure of GDP per capita. a) (10) Before looking at any data, propose a simple economic story (model) for how these two variables might be related. Write a paragraph of no less than 50 words in which you explain your argument. Which is the independent, and which is the dependent variable in your model? (Plausible stories could be told in which either variable could be the independent (or dependent) variable.) b) (10) Whichever way you've chosen to model this problem, execute a linear regression. For one time in your life, you are going to be calculating the slope and intercept estimators in EXCEL (or Google Spreadsheet) using the "by hand" method that was demonstrated in the lectures. DO NOT USE THE BUILT IN EXCEL REGRESSION/VARIANCE/COVARIANCE FEATURES (except to check your work, if you desire). Report your Betahats. c) (10) What percentage of the variation of your dependent variable is explained by the independent? d) (10) Also "by hand," calculate the variance of B. Next, calculate the test statistic and p- value for a hypothesis test that the population slope is zero. (The p-value is going to be extremely small and not be on any t-table. Figure out how you can use Excel to calculate it. (Look up the t.dist functionality in the help menus.)
Expert Answer:
Answer rating: 100% (QA)
Carmop to 13000 by The file Corruptionxls contains countrylevel data on two variables One of these is a measure of perceptions of political corruption This data is assembled by the organization Transp... View the full answer
Related Book For
Statistics Unlocking The Power Of Data
ISBN: 9780470601877
1st Edition
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock
Posted Date:
Students also viewed these mathematics questions
-
This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy. Two alternative investment options are available to evaluate. Challenges are...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
To encourage _________, leaders are encouraged to study the principles of teamwork that prevail in clinical contexts for their application to managerial planning and decision-making contexts....
-
The light from an iron arc includes many different wavelengths. Two of these are at = 587.9782 nm and = 587.8002nm. You wish to resolve these spectral lines in first order using a grating 1.20 cm in...
-
The coefficient of determination R2 measures the percentage of variation in the outcome that is explained by the model. In Exercises 9 and 10, determine whether the statement is true or false. If the...
-
In its 2014 annual report, Merck & Co., Inc., reported that its basic earnings per share were \($4.12\) per share while its diluted earnings per share were \($4.07\) per share. Discuss the factors...
-
Drehman Paving & Flooring Co. installed a brick floor at Cumberland Farms that its salesman promised would be just like another floor Cumberland had installed several years earlier. The bricks in the...
-
jordan hernandez is a tax professional working in a large office. as she is waling to the break room, she sees a stack of completed
-
The trial balance of Pacilio Security Services Inc. as of January 1, 2017, had the following normal balances: Cash ................. 78 , 972 P e t t y C a s h . . . . . . . . . . . . . . . . 100 A c...
-
14. The face value of the bond is $1000. The interest rate is currently 4%. The bond matures in 10 years.
-
Part E Let V = -6.0 +8.5 and 1 V = 4.5 + 4.4 . Determine the magnitude of V1+V2. Express your answer using two significant figures. |1+V2|= Submit Request Answer Part F Determine the direction of...
-
Larkspur Express reports the following costs and expenses in June 2022 for its delivery service. Indirect materials used $8,110 Drivers' salaries $20,160 Depreciation on delivery equipment 14,020...
-
On January 1, 2025, Sunland Company leased equipment to Carla Vista Corporation. The following information pertains to this lease. 1. The term of the non-cancelable lease is 6 years. At the end of...
-
4. Prepare the following entries: A. Co X made a Sale to an affiliate (Z) for goods $50,000 at a cost of $32,000. Co Z received the inventory. Co Z did not sell the inventory at the end of the...
-
tes On January 1, 2024, Rick's Pawn Shop leased a truck from Corey Motors for a six-year period with an option to extend the lease for three years. Rick's had no significant economic incentive as of...
-
Complete each question by providing the required solution ) ( a ) ?Draw a distance - time graph using the data in the table 1 ?below ( i ) ?Scaling the axis ( 1 point ) ( ii ) ?Labelling the axis ( 1...
-
Organizations are increasing their use of personality tests to screen job applicants. What are some of the advantages and disadvantages of this approach? What can managers do to avoid some of the...
-
Every Fourth of July, Nathans Famous in New York City holds a hot dog eating contest, which we discuss in Exercise 2.98. Table 2.21 on page 86 shows the winning number of hot dogs and buns eaten...
-
About 20% of movies coming out of Hollywood are comedies, Warner Bros has been the lead studio for about 9% of recent movies, and about 2% of recent movies are comedies from Warner Bros. Let C denote...
-
The dataset StudentSurvey, introduced on page 4, contains information on hours of Exercise per week and GPA. Here we use a slightly modified version called GPAGender which eliminates missing values...
-
Figure 4. 14 suggests that we can assign each feature vector \(\boldsymbol{x}\) in the iris data set to one of two clusters, based on the value of \(\boldsymbol{u}_{1}^{\top} \boldsymbol{x}\), where...
-
Chelsea Manufacturing, Inc., operates a plant that produces its own regionally marketed Super Salad Dressing. The dressing is produced in two processes, blending and bottling. In the Blending...
-
Salanger Manufacturing Corporation produces a dandruff shampoo in three consecutive processes. The costs of Department 1 for June 2019 were as follows: Department 1 handled the following units during...
Study smarter with the SolutionInn App