Please help with the following problem. I need a profitability analysis for the customers (each TAB is considered ONE customer) in the attached Excel file. I need it split up by each "facility #" customer and then I need a roll-up to include ALL facilities for each customer so we can see big picture how the customer is
1)Np - Chart A receiving inspection station regularly samples 125 incoming washers to determine whether the inner diameter conforms to specifications. The number of nonconforming washers detected in the last 10 lots is shown below. Develop an np-chart to document the findings. Average, UCL, LCL Trends? Runs? Out of Control? Lo
You have taken data from a production process in order to develop an Xbar control chart. You have 25 samples of data with 5 parts measured in each sample to get the Xbar. Use this data shown in the table. Sample Xbar 1 2.12 2 2.22 3 1.98 4 2.24 5 1.97 6 1.99 7 2.1
Why are histograms useful? What are some of the difficulties in creating histograms? Give some examples where a histogram is useful. Here is some back ground info on a histogram: A Histogram shows the frequencies, absolute or relative, that a specific variable takes on certain values. For example, if you rolled a die, you
We handed out 72 spanish surveys and 22 english surveys with the following variables: Age ex:17-25 income ex: 31,000-40,000 Position in your current job ex:administrative i quess those are the variables **************************************************************** then there are 29 questions that were done on each s
The owner of a restaurant serving Continental-style entrees has the business objective of learning more about patterns of patron demand for the Friday to Sunday weekend time period. Data were collected on 630 customers on the type of course ordered and are listed in the table below. Type of Entry Number Served Beef 187 Chi
. Below are the blood types of 16 blood donors. O- A+ O- O+ AB- A- A+ B+ O+ A+ B- O+ A- O+ B- B+ i. Make a frequency table using these 7 blood types: O+, O-, A+, A-, B+, B-, AB- ii. What is (are) the mode(s)? iii. Does it make sense to talk about the average
Search the Web for project planning tools and describe at least 2. Download a demo or two, and build a project so you can see the different PM charts (Gantt, CPM, Pert, etc.). Comment on the ease in which you were able to build each of the charts. Which tool would you recommend to your classmates, if any, and why?
Please help me with an assignment by explaining this problem: Task: Of the estimated natural gas reserves in North America, 4.59 *10^9 m ^3 are in the United States. 2.66*10^9 m^3 are in Canada, and 1.99*10^9 m^3 are in Mexico. In making a circle graph (circular sectors represent percentage of the whole - a pie chart) with a
It is claimed that its better to hire a manager from outside a firm than promote one from within. A human resources analyst at a firm justifies this claim by showing that average performance evaluations tend to be significantly higher for managers hired from outside the firm compared with those promoted from within. Look a
An important idea in data interpretation is choosing which graph to use under which circumstances. Describe the benefits of different graphs for different sets of data: 1) Pictographs 2) Line graphs 3) Circle or pie graphs 4) Histograms and line plots 5) Stem-and-leaf plots
Find the upper and lower control limits for an X-bar chart and R-chart for the width of a chair seat when sample grand mean (based on 30 samples of 6 observations each) is 27 inches and the average range is 0.35 inches. Please use Excel.
If 30 samples of 100 items are tested for nonconformity and 95 of the 3,000 items are defective, find the upper and lower control limits for a p-chart.
Construct a column chart for the data in the excel file state unemployment rates to allow a comparison of the June rate with historical highs and lows. Would any other charts be better to visually covey this information? Why or why not? State Unemployment Rates State June 2008 Rate Historical High Historical Low
1. In constructing a histogram for given data set (let say age data of your community people), how many class intervals will you consider in the graph. Would you tell us the rules to determine the number of class intervals in constructing a frequency table of a continuous outcome measure data? 2. Would you please tell us with a
Statistical Analysis: Descriptive Statistics, Box Plot, Frequency Distribution, Histogram, Pie Chart in EXCEL
Advertising fees are an important source of revenue for any newspaper. In an attempt to boost these revenues and to minimize costly errors, the management of the Herald has established a task force charged with the business objective of improving customer service in the advertising department. Using a web browser, visit this boo
A manufacturere of exercise bicycles is studying the relationship between the number of months an exercise bicycle has been owned and the length of time it was used last week. Data for a random sample of 7 owners are proviced in the table below. Months owned (x) Hours used last week 14
The table is average tuition at private colleges and universities for selected years. Year 1985 1990 1995 2000 2008 Tuition 5330 9335 12335 16212 25122 Using the TI-83, find the least-squares regression line that models the data and graph the data on a scatter plot and use the calculator to estimate the tuition for 2005.
See the attached file. Problem 2.5 The following information is collected from students upon exiting the campus bookstore during the first week of classes: a. Amount of time spent shopping in the bookstore b. Number of textbooks purchased c. Academic major d. Gender Classify each of these variables as categorical o
See attached file for data. Part 1. Each year the local country club sponsors a tennis tournament. Play starts with 128 participants. During each round, half of the players are eliminated. How many players remain after 5 rounds? Chart the decay rate. Part 2. Given the following data: [img src="@17728859"] - Please vie
6. A small business consultant is investigating the performance of several companies. The fourth quarter sales for last year (in thousands of dollars) for selected companies were... 8. A set of data consists of 45 observations between ... 10. A set of data consists of 53 observations. The lowest value is ... 16. The followi
Mount Blanc Hospital is working on improving waiting time in order to give customers better service in their waiting rooms. Forty samples of size 5 were taken at random times from their main waiting room. These data can be found on the attached worksheet. 1) Compute the mean and range of each sample and plot them on cont
The following data were collected on the examination results of biology students in 4 second level biology modules: There were 20 - 30 students in each class: 1. Vertebrate Physiology & Evolution: 56, 57, 67, 75, 45, 35, 56, 67, 82, 91, 58, 60, 61, 63, 76, 54, 36, 45, 67, 57, 60, 63, 76, 78, 50, 60, 54. 2. Practical Ski
See attached files. Ricardo's Widgets makes a critical part for a popular brand of cell phones. Consider the data for 15 samples of size 4 of a key dimension for the part, show in the worksheet. Specifications are 0.110 +/- 0.015. a. Compute control limits for an x-chart using the statistic R/d2 as an estimate of the stand
See the attached data file. Data collection on Century National Bank 1. Display your data in both tabular and graphical formats. 2. Identify some primary data collection methods that could be used to collect data.
There are three tables needed as the columns indicate. 1. Premium/100 workers 2. Frequency Rates (LTC/100) 3. Average Cost Per LTC I need to show the trends, in an easy digestible way. It can be in Excel. I just need it to look graphically appealing.
A. What distinguishes a histogram from a bar chart? B. What would be an appropriate graphical representation to show the dispersion of home prices in a particular city, such as San Diego? Consider what would be the dependent (y) and independent (x) variables? Explain your reasoning.
Sketch a scatter plot that could represent data from each of the following. Label the axes to indicate the independent and dependent variable. 1. People's ages (starting at 20) and their reaction times 2. Oven temperature and the cooking time for a turkey 3. Exposure to sunlight and the risk of heart attacks
See the attached file. I need some help getting started with this assignment. I don't want the assignment done for me. I just have no idea where to start. I have limited experience with Excel. The actual assignment is attached and it includes the instructions. I would appreciate it if someone was able to direct me on the
Statistics: Scale of Measurement, Frequency Distribution, Histogram, Pie Chart, Stem and Leaf Plot, Graph, Scatter Plot
Please refer to the attached Excel Sheets fo the data. 1. For the following variables, state what kind of measurement is being used? (Nominal, Ordinal, Interval, Ratio) a. Geographic Region b. Control c. Payroll Expenditure 2. Create a frequency distribution for the 'beds' var