Summary from Practice Test

docx

School

Western Sydney University *

*We aren’t endorsed by this school

Course

1250

Subject

Economics

Date

Feb 20, 2024

Type

docx

Pages

6

Uploaded by DeanBook17230

Report
Summary from Practice Test: Question 1: In Australia, recycling is essential to address UN SDG Goal 12: Ensuring sustainable consumption and production patterns. Exchange for Change coordinates between NSW and ACT’s Return and Earn container deposit scheme, making recycling easy for consumers, beverage suppliers, and the waste industry. A random sample of households’ data on per-person tonnes of recycling from ACT and NSW is stored in an Excel file ReturnAndEarn.xlsx. Download the Excel file and use Excel to undertake an appropriate hypothesis test to address the research question: Appropriate Test - Two sample T-Test Which graphical display(s) would be the best to check the normality assumption for this hypothesis? - Figure 1 and 2 Excel Output:
Absolute Value - 56.89 Degrees of Freedom - 72 P-value - lower than 0.05 Conclusion - Significant difference between the two samples (ACT could be greater than NSW) Question 2: In Australia, recycling is essential to address UN SDG Goal 12: Ensuring sustainable consumption and production patterns. Exchange for Change coordinates with ACT’s Return and Earn container deposit scheme, making recycling easy for consumers, beverage suppliers, and the waste industry. A random sample of the same households’ data on per person tonnes of recycling from ACT for the 2020/2021 and 2021/2022 financial years is stored in an Excel file ReturnAndEarn_2_years.xlsx. Download the Excel file and use Excel to undertake an appropriate hypothesis test to address the research question:
Appropriate Test - Paired T-Test Which graphical display(s) would be the best to check the normality assumption for this hypothesis? - Figure 3 Excel Output: Absolute Value of T-Statistic - 1.562 P-Value - > 0.05 Degrees of freedom - 30 The test shows that the average tonnes recycled per person was not significantly different between the 2020/2021 and 2021/2022 financial years.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Question 3: The World Health Organization maintains a wide range of data collections related to global health and well-being. The file InfantMortality.xlsx contains information for a random sample of countries (n= 47) on various health issues. A researcher is investigating the relationship between Total Expenditure on Health as % of GDP 2003 (TExpen_2003) and Infant Mortality rate (per 1000 live births) in 2004 (IM_2004). Specifically, she wants to answer the following research question: To check the linear relationship between Total Expenditure on Health as % of GDP 2003 (TExpen_2003) and Infant Mortality rate (per 1000 live births) in 2004 (IM_2004), we use - Figure 1 To check the normality of residuals, we use - Figure 3 If there were outliers in the data, what would be the best action to obtain a linear regression equation to model the relationship between the variables? - Exclude the outliers Excel Output:
The slope of the least squares regression line is? - Negative The absolute value of the test statistic for testing the slope of the regression line is  21.698 (has to be a positive value), with a df of 45. Select the most appropriate conclusion to the question “Is there a statistically significant linear relationship between the two variables?” In other words, “Is the Total Expenditure on Health as % of GDP 2003 (TExpen_2003) a useful predictor for the Infant Mortality rate (per 1000 live births) in 2004 (IM_2004)?”. There is a significant negative linear relationship between the two variables. The correlation between the two variables (TExpen_2003 and IM_2004) is -0.955
Use the regression equation to predict the Infant Mortality rate (per 1000 live births) in 2004 (IM_2004) for a country that had a total expenditure (T_Expen_2003) of 4 - 108.21
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help