Question

In: Statistics and Probability

1\ The Excel file HATCO1 consists of data related to predicting the level of business (Usage...


1\ The Excel file HATCO1 consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO. The following are the independent variables.
• Delivery Speed—amount of time it takes to deliver the product once an order is confirmed.
• Price Level—perceived level of price charged by product suppliers.
• Price Flexibility—perceived willingness of HATCO representatives to negotiate price on all types of purchases.
• Manufacturing Image—overall image of the manufacturer or supplier.
• Overall Service—overall level of service necessary for maintaining a satisfactory relationship between supplier and purchaser.
• Sales Force Image—overall image of the manufacturer’s sales force.
• Product Quality—perceived level of quality of a particular product.
• Size of Firm—size relative to others in this market (0 = small; 1 = large) .
Responses to the first seven variables were obtained using a graphic rating scale, where a 10‐cm line was drawn between endpoints labeled “poor” and “excellent.” Respondents indicated their perceptions using a mark on the line, which was measured from the left endpoint. The result was a scale from 0 to 10 rounded to one decimal place.
1) You have been asked to analyze these data. Your analysis should include a descriptive summary of the data using appropriate charts and visual displays, recommendations on whether any interventions are necessary based on the benchmark targets, whether any differences exist between firm size and customer ratings, and between firm size and usage level. Use appropriate hypothesis tests to support your conclusions and summarize your findings in a formal report to the Vice President of Purchasing.
2) Using the tools in this chapter 6 and 7 (regression and forecasting), conduct a complete analysis to predict Usage Level. Be sure to investigate the impact of the categorical variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions. Also stratify the data by firm size to account for any differences between small and large firms. Write up your results in a formal report to HATCO management.

Solutions

Expert Solution


Related Solutions

please no excel usage Assume you create a portfolio that consists of a long position in...
please no excel usage Assume you create a portfolio that consists of a long position in two 3-month European call options and a short position in one 3-month European put option on euros. Both the call and the put options have 125,000 euros attached. The strike price for the call and put options is $1.1 and $1.2, respectively. The call and put premiums are $.02 and $.05, respectively.Calculate the profit/loss (in terms of USD) on your portfolio if the spot...
In the Excel data file, the tab labeled Question 1 contains data on the number of...
In the Excel data file, the tab labeled Question 1 contains data on the number of times boys and girls raise their hands in class. Conduct the t-test: Two-Sample Assuming Equal Variances. Males 9,8,4,9,3,8,10,8,9,10,7,6,12 Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8 a. What is the null hypothesis? b. What is the research hypothesis? c. Why run a Two-Sample Assuming Equal Variances t-test? d. Interpret the findings. What are the results of the hypothesis test? Can you reject the null hypothesis?
The Excel data for this assignment shows the annual energy usage in kWh for a random...
The Excel data for this assignment shows the annual energy usage in kWh for a random sample of 250 detached single-family homes in the Southeast. A contractor building a new housing development in Town A hypothesizes that mean annual energy usage will be below 16,500 kWh per household. Use the data to run a single mean hypothesis test and calculate a test statistic in Excel. In your method summary, state the hypothesis and your assumptions. In your resulting conclusions, state...
The Excel file Myatt Steak House provides five years of data on key business results for...
The Excel file Myatt Steak House provides five years of data on key business results for a restaurant. Identify the leading and lagging measures, find the correlation matrix, and propose a cause-and-effect model using the strongest correlations. Myatt Steak House 2010 2011 2012 2013 2014 Order Accuracy X1 86.0% 86.0% 89.0% 90.0% 95.0% Timeliness of Delivery X2 84.0% 82.0% 86.0% 93.0% 95.0% Table Cleanliness X3 4.8 4.8 5.1 5.6 5.8 Customer Satisfication X4 93.4% 93.2% 94.2% 95.3% 96.7% Total #...
how to export source data to excel file in python?
how to export source data to excel file in python?
Which level consists of related organs that work to achieve a common function? A.Organ Level B.cellular...
Which level consists of related organs that work to achieve a common function? A.Organ Level B.cellular level C.chemical level D.Tissue level E. Organ system level
Use the Excel data file found in the Course Content from Module #1. Be sure to...
Use the Excel data file found in the Course Content from Module #1. Be sure to submit your file through the Project #4 drop box for this week. Masterfoods USA states that their color blends were selected by conducting consumer preference tests, which indicated the assortment of colors that pleased the greatest number of people and created the most attractive overall effect. On average, they claim the following percentages of colors for M&Ms® milk chocolate candies: 24% blue, 20% orange,...
Assignment 1 Note: submit the following 1- "Excel file" include data and graph and analysis "please...
Assignment 1 Note: submit the following 1- "Excel file" include data and graph and analysis "please do not use anything rather than excel" 2- a functional code that performs all the required operations in 1 & part A 1-Collect set of data from the web. About coronavirus evolution in different countries considering other factors like median age of populations, health care systems etc. you are required to perform statistical analysis of this data by calculating the different statistical metrics (like...
EXCEL #1 ASSIGNMENT: Aspire Food Group: ORIGINAL PROBLEM DATA (1ST Excel File): CHECK FIGURES: Conversion: $2.38...
EXCEL #1 ASSIGNMENT: Aspire Food Group: ORIGINAL PROBLEM DATA (1ST Excel File): CHECK FIGURES: Conversion: $2.38 per EU                            7/31/2020 Ending Balance WIP $59,589 A unit of production is one bag of 1,000 crickets. For example, in the brooder department process, there were 6,000 physical units in July in the beginning work-in-process inventory; which are 6,000 bags (each bag contains 1,000 crickets). The following information is available for the brooding department during July for Aspire Food Group Beginning work in...
The data set for this question set (Tab Q1 in the Excel data file) comes from...
The data set for this question set (Tab Q1 in the Excel data file) comes from a research project that tracks the elderly residents in a community to monitor their cognitive function and general health. Based on the literature, education is considered a protective factor against dementia, and memory decline is usually the first sign of dementia. So the researchers would like to know whether education level (measured in number of years of formal schooling) is correlated with memory function...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT