Question

In: Economics

The dataset ToyotaCorolla.jmp contains data on used cars on sale during the late summer of 2004...

The dataset ToyotaCorolla.jmp contains data on used cars on sale during the late summer of 2004 in the Netherlands. It has 1436 records containing details on 38 attributes, including Price, Age, Kilometers, HP, and other specifications. (a.) Explore the data using the data visualization (e.g., Graph > Scatterplot Matrix and Graph > Graph Builder) capabilities of JMP. Which of the pairs among the variables seem to be correlated? (three or four correlations please).

Multivariate Correlations

Price

Age_08_04

KM

HP

CC

Quarterly_Tax

Weight

Guarantee_Period

Price

1.0000

-0.8766

-0.5700

0.3150

0.1264

0.2192

0.5812

0.1466

Age_08_04

-0.8766

1.0000

0.5057

-0.1566

-0.0981

-0.1984

-0.4703

-0.1526

KM

-0.5700

0.5057

1.0000

-0.3335

0.1027

0.2782

-0.0286

-0.1389

HP

0.3150

-0.1566

-0.3335

1.0000

0.0359

-0.2984

0.0896

0.0762

CC

0.1264

-0.0981

0.1027

0.0359

1.0000

0.3070

0.3356

-0.0177

Quarterly_Tax

0.2192

-0.1984

0.2782

-0.2984

0.3070

1.0000

0.6261

-0.1634

Weight

0.5812

-0.4703

-0.0286

0.0896

0.3356

0.6261

1.0000

-0.0129

Guarantee_Period

0.1466

-0.1526

-0.1389

0.0762

-0.0177

-0.1634

-0.0129

1.0000

Solutions

Expert Solution

The horizontal axis contains the variables in same order as present diagonally/

Now stating the correlation between variables.

WPC: WEAK POSITIVE CORRELATION. (If slope positive but flat)

WNC: WEAK NEGATIVE CORRELATION (If slope neagitve but flat)

SPC: STRONG POSITIVE CORRELATION (If slope positive but Steep)

SNC: STRONG NEGATIVE CORREATION (If slope negative but steep)

Defining Correlation Price Age_08_04 KM HP CC Quarterly_Tax Weight Guarantee_Period
Price PerfectPositiveCorrelation
Age_08_04 SNC PerfectPositiveCorrelation
KM SNC SPC PerfectPositiveCorrelation
HP WPC WNC WNC PerfectPositiveCorrelation
CC WPC WNC WPC WPC PerfectPositiveCorrelation
Quarterly_Tax WPC WNC WPC WNC WPC PerfectPositiveCorrelation
Weight SPC WNC WNC WPC WPC SPC PerfectPositiveCorrelation
Guarantee_Period WPC WNC WNC WPC WNC WNC WNC PerfectPositiveCorrelation

Related Solutions

The dataset HomesForSaleCA contains a random sample of 30 houses for sale in California. Suppose that...
The dataset HomesForSaleCA contains a random sample of 30 houses for sale in California. Suppose that we are interested in predicting the Size (in thousands of square feet) for such homes. State Price Size Beds Baths CA 500 3.2 5 3.5 CA 995 3.7 4 3.5 CA 609 2.2 4 3 CA 1199 2.8 3 2.5 CA 949 1.4 3 2 CA 415 1.7 3 2.5 CA 895 2.1 3 2 CA 775 1.6 3 3 CA 109 0.6 1...
Homes for Sale The dataset HomesForSale has data on houses available for sale in three Mid-Atlantic...
Homes for Sale The dataset HomesForSale has data on houses available for sale in three Mid-Atlantic states (NY, NJ, and PA). Table 1 shows the mean and standard deviation from the three Mid-Atlantic states, in thousands of dollars. Use this table, the knowledge that within the US the average house sells for about 265 thousand dollars1, and a 5% significance level to answer the following questions. State n Mean Std. Dev. New York 30 565.6 697.6 New Jersey 30 388.5...
You will be performing an analysis on a dataset that contains data on fertility and life...
You will be performing an analysis on a dataset that contains data on fertility and life expectancy for 198 different countries. All data is from the year 2013. The fertility numbers are the average number of children per woman in each of the countries. The life expectancy numbers are the average life expectancy in each of the countries. You will be turning in a paper that should include section headings, graphics and tables when appropriate and complete sentences which explain...
kelly's blue book publishes data on new used cars. The following table contains the manufacturer's suggested...
kelly's blue book publishes data on new used cars. The following table contains the manufacturer's suggested retail price for four vehicles, model years 2006 and 2007. we are interested in the difference in price between the 2006 models and the 2007 models. Assume that the population of price differences is normally distributed. Subaru Honda Toyota Nissan Forester CR-V RAV-4 Sentra 2006 2007 $22,420 $20,990 $22,980 $13,815 $21,820 $22,395 $23,630 $15,375 use the mean of the differences, d=753.75, and the standard...
The dataset in the file Lab11data.xlsx contains data on Crimini mushrooms. The factor variable is the...
The dataset in the file Lab11data.xlsx contains data on Crimini mushrooms. The factor variable is the weight of the mushroom in grams and the response variable is the total copper content in mg. 1. Plot Copper vs. Weight and describe. 2. Find least squares regression line and interpret slope in the words of the problem. 3. Find the coefficient of determination (R2) and interpret in context. 4. Find the correlation coefficient (R) and interpret in context. 5. Find and interpret...
The dataset ’anorexia’ in the MASS package in R-Studio contains data for an anorexia study. In...
The dataset ’anorexia’ in the MASS package in R-Studio contains data for an anorexia study. In the study, three treatments (Treat) were applied to groups of young female anorexia patients, and their weights before (Prewt) and after (Postwt) treatment were recorded. The three treatments adminstered were no treatment (Cont), Cognitive Behavioural treatment (CBT), and family treatment (FT). Determine at the 5% significance level if there is a difference in mean weight gain between those receiving no treatment and those receiving...
The dataset ’anorexia’ in the MASS package in R-Studio contains data for an anorexia study. In...
The dataset ’anorexia’ in the MASS package in R-Studio contains data for an anorexia study. In the study, three treat- ments (Treat) were applied to groups of young female anorexia patients, and their weights before (Prewt) and after (Postwt) treatment were recorded. The three treatments adminstered were no treatment (Cont), Cognitive Behavioural treatment (CBT), and family treatment (FT). Determine at the 5% significance level if there is a difference in mean weight gain between those receiving no treatment and those...
2. The dataset ’anorexia’ in the MASS package in R-Studio contains data for an anorexia study....
2. The dataset ’anorexia’ in the MASS package in R-Studio contains data for an anorexia study. In the study, three treatments (Treat) were applied to groups of young female anorexia patients, and their weights before (Prewt) and after (Postwt) treatment were recorded. The three treatments adminstered were no treatment (Cont), Cognitive Behavioural treatment (CBT), and family treatment (FT). Determine at the 5% significance level if Cognitive Behavioral treatment is effective in helping patients gain weight. Perform all necessary steps for...
The dataset Golfers2008.xlsx saved in Datasets in Blackboard contains data on the top 40 golfers in...
The dataset Golfers2008.xlsx saved in Datasets in Blackboard contains data on the top 40 golfers in 2008. This was the year when Tiger Woods won the U.S. Open in June and then had year-ending surgery. Using all the explanatory variables, run a regression predicting Earnings per Round. Determine the best fit model by removing any insignificant x-variables.   Rerun the analysis with your best fit model. Make a clear notation of which model is your best-fit model by labeling the worksheet...
The data below are the temperatures on randomly chosen days during the summer and the number...
The data below are the temperatures on randomly chosen days during the summer and the number of employee absences at a local company on those days. Temperature,x: 72,85, 91, 90, 88, 98, 75, 100, 80 Number of absences, y: 3, 7, 10, 10 8, 15, 4, 15, 5 A) Find the residual when temperature is 98. Analyze the result.   B) Test the claim, at the α = 0.05 level of significance, that a linear relation exists between the temperature and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT