2) Using the excel data file “shopping” which shows the reasons American and East Asian students...

2) Using the excel data file “shopping” which shows the reasons American and East Asian students from a large Midwestern university may buy from catalogs.

a) (10 pts) For the Asian students make a pie chart of the reason they buy using a catalog. (Hint you will need to weigh cases by Asian)

b) (10 pts) Make a bar chart showing the counts for the reasons American students buy using a catalog. (Hint you will need to

weigh cases by American)

[Shopping Excel Data]

Reason	American	Asian
Save Time	29	10
Easy	28	11
Low Price	17	34
Live Far From Stores	11	4
No Pressure to Buy	10	3
Other	20	7

Expert Solution

orchestra answered 1 year ago

1) Using the excel data file “US violent crime” which shows the violent crime rate in...

1) Using the excel data file “US violent crime” which shows the violent crime rate in the US from 1960 to 2012: (20 pts) Make a time series plot of the data (5 pts each 25 pts total) Determine the following: Mean, Median, Standard deviation, Q1 and Q3. (25 pts) Make a histogram of the data. Hint the year is not used, you need to determine how many years fall into each of the classes. (7) What are your thoughts...

Using Excel Data in Travel file shows the average number of rooms in a variety of...

Using Excel Data in Travel file shows the average number of rooms in a variety of U.S cities and the average room rate and the average amount spent on entertainment. A company that run events for hotel residents wants to predict the amount spent on entertainment based on room rate and number of rooms. Run the regression analysis. Are the coefficients statistically significant? Do we need to drop one of these variable? Which variable? Interpret the slope of the estimated...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas Site (Chapter 10 Data Files), gives the weights (in pounds) of randomly selected checked bags for an airline’s International and Domestic flights on the same day. First, test to determine if the variances in weights of checked bags differ between international and domestic flights. Show and follow the 7 steps for hypothesis testing. (8 points) Verify your results in part a. using Minitab; attach...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas Site (Chapter 10 Data Files), gives the weights (in pounds) of randomly selected checked bags for an airline’s International and Domestic flights on the same day. First, test to determine if the variances in weights of checked bags differ between international and domestic flights. Show and follow the 7 steps for hypothesis testing. (8 points) Verify your results in part a. using Minitab; attach...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas Site (Chapter 10 Data Files), gives the weights (in pounds) of randomly selected checked bags for an airline’s International and Domestic flights on the same day. First, test to determine if the variances in weights of checked bags differ between international and domestic flights. Show and follow the 7 steps for hypothesis testing. (8 points) Verify your results in part a. using Minitab; attach...

The data file ExamScores shows the 40 students in a TOM 3010 course exam scores for...

The data file ExamScores shows the 40 students in a TOM 3010 course exam scores for the Midterm and Final exam. Is there statistically significant evidence to show that students score lower on their final exam than midterm exam? Provide the p-value for this analysis. Student ID # Midterm Final 56065 97 64 79499 95 85 59716 89 72 83504 79 64 77735 78 74 57760 87 93 78204 83 70 81177 94 79 54398 76 79 79829 79 75...

International students from Asian countries often have trouble adjusting to American classrooms. Researchers hypothesize that Asian...

International students from Asian countries often have trouble adjusting to American classrooms. Researchers hypothesize that Asian students might talk less often. A study evaluated the propensity of Asian males to speak in class. On the scale in the study, American males have a mean of 10.0. A random sample of 64 Asian males had a sample mean of 8.75 and sample standard deviation of 2.57. Conduct a hypothesis test at α = 0.05 to see if Asian males speak less...

Question 7 Which of the following is not a proper description of East Asian economies? a....

Question 7 Which of the following is not a proper description of East Asian economies? a. A fast recovery from the 1997 financial crisis. b. Focusing on the WTO membership and no FTAs among the nations. c. A successful and strong join to the global supply chain management in manufacturing. d. People in the region have begun to aware the importance of the environmental protection.

Using the data provided in the excel file, show all of your work for the following...

Using the data provided in the excel file, show all of your work for the following calculations: a.) mean temperature of unmixed reagents (oC) b.) δελταT from graph (oC) c.) q absorbed by reaction mixture (J) d.) q absorbed by calorimeter, stirrer, and thermometer (J) e.) q total absorbed (J) f.) q total released (J) g.) calculation to show limiting reagent h.) deltaH neutralization for the reaction (kJ/mole of acid) A student reacted 100.0 mL of 0.9800 M HCl with...

Using the data in the Excel file under the tab Problem1, develop a regression equation for...

Using the data in the Excel file under the tab Problem1, develop a regression equation for a country’s lung cancer death rate based on cigarette consumption. Is this a good regression model? Why or why not? If Cigarette Consumption was 725, what would you predict the Lung Cancer Death Rate to be? Using your regression model, what is the Residual Value for Finland? Do you think there are any outliers in the model? If so, what would you do with them? Country...

Question

2) Using the excel data file “shopping” which shows the reasons American and East Asian students...

Solutions

Expert Solution

Related Solutions

1) Using the excel data file “US violent crime” which shows the violent crime rate in...

Using Excel Data in Travel file shows the average number of rooms in a variety of...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas...

2. Data, which may be found in the Excel file named “Luggage” on the course Canvas...

The data file ExamScores shows the 40 students in a TOM 3010 course exam scores for...

International students from Asian countries often have trouble adjusting to American classrooms. Researchers hypothesize that Asian...

Question 7 Which of the following is not a proper description of East Asian economies? a....

Using the data provided in the excel file, show all of your work for the following...

Using the data in the Excel file under the tab Problem1, develop a regression equation for...