Question

In: Statistics and Probability

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

Solutions

Expert Solution

orchestra answered 2 years ago
Next > < Previous

Related Solutions

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...
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.
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...
Please post a screenshot of excel file. Application assignment: using Excel Descriptive Statistics of Quantitative Data...
Please post a screenshot of excel file. Application assignment: using Excel Descriptive Statistics of Quantitative Data (measured on Ratio scale). Use this file for submission, but use Excel to do your work and copy and paste in the appropriate places identified in this word file. Note: The following Excel functions in answering Questions 1 and 2 below. AVERAGE , AVEDEV, COUNT, CORREL, MIN, MAX, MDIAN, MODE, STDEV , STDEVP, STDEV.P, and STDEV.S Q4. Use the x data and define a...
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT