My findings when analyzing the number of returns by state
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Statistics
Date
Feb 20, 2024
Type
docx
Pages
1
Uploaded by SuperFangCobra37
My findings when analyzing the number of returns by state, show that Massachusetts has the highest number of returns. The second and third states with the highest number of returns are Arkansas and Oregon. In Massachusetts the SKU that is being returned the most in the ENT-48-10F with 972 returns. In
Arkansas, the ADV-24-10C is being returned (844) and in Oregon the BAS-08-1 C is being returned at a high rate of 840 returns. The reason for these SKU’s being returned have a reason of Defective.
SELECT Collaborators.state AS STATE, COUNT(*) AS PRODUCT_SALES_NUMBER FROM Collaborators INNER JOIN Orders ON Collaborators.CollaboratorID = Orders.CollaboratorID GROUP BY STATE ORDER BY PRODUCT_SALES_NUMBER DESC LIMIT 15;
I have also gathered data on the percentages of returns. The states that have the highest percentage numbers are Massachusetts (2.6%), Arkansas (2.2%), and Oregon (2.2%). The product SKU that has the highest return rate is BAS-48-1 C (22%). The second and third SKU’s that have a high return percentage are ENT-48-40F (16%), and ENT-48-10F (11%). The return frequency of SKU BAS-48-1 C is 8282. SKU’S ENT-48-40F AND ENT-48-10F have the second and third highest return frequency rate with 6118 and 4287.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
The National Electronic Injury Surveillance System tracks injuries reported from
hospital admissions across the United States (Consumer Product Safety Commission
2018). For the data in 2017, we extracted all incidences of hand injuries that
referenced punching a wall. There were 1843 such cases. The surveillance system also
records some of the properties of the patients, including gender. Of all cases where a
person was admitted to a hospital for injuries from punching a wall, 1352 were
recorded as male and 491 were recorded as female.
a. Do an appropriate hypothesis test to ask whether the proportion of males among
wall-punchers is 50%.
arrow_forward
A study conducted at the University of Denver investigated whether babies take longer to learn to crawl
in cold months, when they are often bundled in clothes that restrict their movement, than in warmer
months. Infants born during the study year were split into twelve groups, one for each birth month. We
consider the average crawling age of babies in each group against the average temperature when the
babies are six months old (that's when babies often begin trying to crawl). Temperature is measured in
degrees Fahrenheit and age is measured in weeks.
34
33
32
31
30-
29
30
40
50
60
70
Temperature (F)
a) Describe the relationship between temperature and crawling age. Choose all answers that apply.
There is strong, negative, linear relationship between termperature and crawling age
nThere is a somewhat moderate, negative, linear relationship between temperature and crawling
age
nThere is a moderate, positive, linear relationship between the temperature and crawling age
The point at the…
arrow_forward
An aircraft emergency locator transmitter (ELT) is a device designed to transmit a
signal in the case of a crash. The Altigauge Manufacturing Company makes 80% of
the ELTS, the Bryant Company makes 15% of them, and the Chartair Company makes
the other 5%. The ELTS made by Altigauge have a 4% rate of defects, the Bryant ELTS
have a 6% rate of defects, and the Chartair ELTS have a 9% rate of defects (which
helps to explain why Chartair has the lowest market share).
a. If an ELT is randomly selected from the general population of all ELTS, find the
probability that it was made by the Altigauge Manufacturing Company.
b. If a randomly selected ELT is then tested and is found to be defective, find the
probability that it was made by the Altigauge Manufacturing Company.
c. What is the probablity that a randomly selected ELT is defective?
arrow_forward
An aircraft emergency locator transmitter (ELT) is a device designed to
transmit a signal in the case of a crash. The Altigauge Manufacturing
Company makes 80% of the ELTS, the Bryant Company makes 15% of
them, and the Chartair Company makes the other 5%. The ELTS made
by Altigauge have a 4% rate of defects, the Bryant ELTS have a 6% rate
of defects, and the Chartair ELTS have a 9% rate of defects (which helps
to explain why Chartair has the lowest market share).
i)
If an ELT is randomly selected from the general population
of all ELTS, find the probability that it was made by the
Altigauge Manufacturing Company.
If a randomly selected ELT is then tested and is found to be
ii)
defective, find the probability that it was made by the
Altigauge Manufacturing Company.
arrow_forward
Cintas has installed three smoke detectors in its stockroom. The installer asserts that each detector is 90% likely to detect a fire within 30 seconds of ignition. Assuming the three detectors function independently, how likely is it that a fire will be detected within 30 seconds?
arrow_forward
Burning fuels in power plants and motor vehicles emits carbon dioxide (CO2), which contributes to global warming. The
CO2 emissions (metric tons per capita) for countries varies from 0.02 in Burundi to 44.02 in Qatar. Although the data set
includes 214 countries, the CO2 emissions of 15 countries are not available on the World Bank database. The data set is
too large to display but the data for the first five countries is given. Use the full data set with data on the 214 countries to
answer the questions.
To access the complete data set, click the link for your preferred software format:
Excel Minitab JMP SPSS TI R Mac-TXT PC-TXT CSV Crunchlt!
Country CO2 Emissions (Metric Tons per Capita)
Aruba
23.92
Andorra
5.97
Afghanistan
0.43
Angola
1.35
Albania
1.61
Find the mean and the median for the full data set. Round your answers to three decimal places.
The mean for these data is
tons per person
The median for these data is
tons per person
arrow_forward
A study was performed to evaluate the support for increasing the speed limit between the residents. A
random sample of 500 residents of Marietta - Georgia found that 385 were in favor of increasing the
highway speed limit to 75 mph, while another sample of 400 residents of Kennesaw - Georgia found that
267 were in favor of the increased speed limit. Do these data indicate that there is a difference in the
support for in increasing the speed limit between the residents of the two cities? Use a = 0.05.
(a) Test the hypothesis Ho: P1 = p2 versus H1: P1 # P2. What is zo?
(b) Is it reasonable to conclude that there is a difference in the support for increasing the speed limit
between the residents of the two cities?
arrow_forward
A recent drug survey showed an increase in the use of drugs and alcohol among local high school seniors as compared to the national percent. Suppose that a survey of 100 local seniors and 100 national seniors is conducted to see if the proportion of drug and alcohol use is higher locally than nationally. Locally, 65 seniors reported using drugs or alcohol within the past month, while 60 national seniors reported using them.
arrow_forward
The Virginia Department of Health publishes COVID-19 vaccination data on their website. As of 10/5/2021, 60.6% of the population of Virginia is fully vaccinated. This rate varies drastically from county to county. Specifically, Fairfax County’s full vaccination rate is 74% and Lee County’s full vaccination rate is 40%. A researcher took a random sample of 14 individuals from Fairfax County and another random sample of 14 individuals from Lee County and asked them whether they could verify that they are fully vaccinated. Each sample was selected in a single day.
1. Calculate the mean and standard deviation of the number of individuals from Fairfax County and Lee County in this sample who are fully vaccinated. Show your work using the binomial mean and binomial standard deviation formulas and provide your two means and two standard deviations in your document. Round your answers to two decimal places. (It is not necessary to use StatCrunch for this part.)
2. Calculate the probability…
arrow_forward
According to scientists, the cockroach has had 300 million years to develop a resistance to destruction. In a study conducted by researchers,
6 comma 0006,000
roaches (the expected number in a roach-infested house) were released in the test kitchen. One week later, the kitchen was fumigated and
18 comma 10718,107
dead roaches were counted, a gain of
12 comma 10712,107
roaches for the 1-week period. Assume that none of the original roaches died during the 1-week period and that the standard deviation of x, the number of roaches produced per roach in a 1-week period, is
1.61.6.
Use the number of roaches produced by the sample of
6 comma 0006,000
roaches to find a
9595%
confidence interval for the mean number of roaches produced per week for each roach in a typical roach-infested house.
Find a 95% confidence interval for the mean number of roaches produced per week for each roach in a typical roach-infested house.
arrow_forward
A study shows that 80% of the population was vaccinated against the Venusian flu but 2% of the
vaccinated population got the flu anyway. If 10% of the total population got this flu, what
percent of the population either got the vaccine or got the disease?
arrow_forward
The data for this exercise was obtained from
https://www.currentresults.com/Weather/Florida/yearly-florida-rainfall.php 2 .
Tourists often hear about the wonderful, warm Florida weather; they live in
blissful ignorance of the freezes experienced in the northern parts of the
state. A tourism organization wants to open up the entire state to tourists.
They know that not everyone is drawn to hot, sunny beaches, so they want
to advertise the advantages of visiting other parts of the state. One of the
first things they need to do is educate potential tourists about the weather.
And part of that involves informing them about the average rainfall across
the state. Your task is to help the tourism organization figure out what the
average rainfall in Florida is like. Rainfall data is provided below.
The table below gives the typical yearly rainfall in some parts of Florida.
Place
Rainfall
(inches per year)
Monticello
56.8
Niceville
71.0
Tampa
46.3
Lakeland
54.8
St. Augustine
Lake City
49.0
52.6…
arrow_forward
Although a research study is typically conducted with a relatively small group of participants
known as a
most researchers hope to generalize their results to a much larger
group known as a
arrow_forward
do number 2 need it fast!!
arrow_forward
Researchers investigated two kinds of laugh tracks – one with posed laughter and one with spontaneous laughter. Recall that to create the posed laughter laugh track, the researchers asked people to laugh and recorded the results. The researchers also tested the same 40 jokes with a spontaneous laughing laugh track, which they created by having people watch funny videos and recording their laughter. The data can be found in the file LaughTypes in pictures. Put these data into the Matched Pairs applet to investigate whether the type of laughter makes a difference in the ratings of the jokes and also do parts (a) (b) and (c):
arrow_forward
A person with tuberculosis is given a chest x-ray. Four tuberculosis x-ray specialists examine each x-ray independently. If each specialist can detect tuberculosis 83% of the time when it is present, what is the probabilty that at least 1 of the specialists will detect a person positive.
arrow_forward
Why won't the whiteboard image show up?
arrow_forward
A researcher wants to determine the specificity of mammograms to determine how effective they are at diagnosing women who have breast cancer. Assume the researcher obtained the results below from a study: Out of a total of 18 women with breast cancer, 12 screened positive and 6 screened negative on the mammogram.
Out of a total of 82 women without breast cancer, 5 screened positive and 77 screened negative on the mammogram.
Calculate and interpret the specificity of mammograms for detecting breast cancer.
arrow_forward
A medical student at a community college in city Q wants to study the factors affecting the systolic blood pressure of a person (Y). Generally, the systolic blood pressure depends on the BMI of a person (B) and the age of the person A. She wants
to test whether or not the BMI has a significant effect on the systolic blood pressure, keeping the age of the person constant. For her study, she collects a random sample of 150 patients from the city and estimates the following regression
function:
Y= 15.50 +0.90B + 1.10A.
(0.48) (0.35)
The test statistic of the study the student wants to conduct (Ho: B, =0 vs. H4: B, #0), keeping other variables constant is.
(Round your answer to two decimal places.)
At the 5% significance level, the student will
v the null hypothesis.
Keeping BMI constant, she now wants
test whether the age of a person (A) has no significant effect or a positive effect on the person's systolic blood pressure.
So, the test statistic associated with the one-sided test the…
arrow_forward
An aircraft emergency locator transmitter (ELT) is a device designed to transmit a signal in the case of a crash. Company A makes 80% of the ELTs, Company B makes 15% of them and Company C makes the other 5%. The ELTs made by Company A have a 7.8% rate of defects, the Company B ELTs have a 6.3% rate of defects and the Company C ELTs have 6.4% rate of defects. If a randomly selected ELT is tested and found to be defective, find is the probability that it was made by Company A? Give your answer to three decimal places.
arrow_forward
An observer at a busy bus stop did a 30-minute study of 3 buses. Given the following
-Alight time =2 sec
-Board time=3 sec
-Door opening time =5 sec
Determine the number of passengers alighting from the back door for the 3 buses
arrow_forward
In the city of AZ, there are two supermarkets, X-Mart and Y-Mart. It is assumed that every shopper makes a purchase once a week at one of these supermarkets (not both).In a study, 100 samples of shoppers were taken over 10 weeks. From the study, it is known that if a shopper goes to X-Mart in one week, 85 people will continue to shop at X-Mart in the following week, and if a shopper goes to Y-Mart in one week, 70 people will continue to shop at Y-Mart in the following week.Create a transition probability table and matrix for this scenario, and then If in the first week Ivankov buys from X-Mart, what is the probability that Terry will buy from X-Mart in the third and fourth weeks?
arrow_forward
An automotive company used two different drivers to test the fuel economy of its latest crossover model. Each driver tested the same 20 vehicles from the factory. When the supervisor reviewed the data, she thought it looked like Driver A had different fuel economies than Driver B on average for the different vehicles and decided to test the data. To test the data, she first separated the data into pairs, with each car tested as a pair. The data is given below, with the fuel economy for each car given in miles per gallon. Assume that both populations are normally distributed.
Use Excel to test if the true mean difference between Driver A and Driver B is significantly different from zero, where α=0.05, where each difference is calculated as Driver A−Driver B. Identify the t-test statistic, rounding to two decimal places, and the p-value, rounding to three decimal places.
Pair
DriverA
DriverB
3
35
31
4
33
35
5…
arrow_forward
In a study done in Michigan, it was determined 38 (out of 62) poor children who attended preschool needed social services later in life compared to 49 (out of 61) poor children who did not attend preschool. Does this study provide significant evidence that preschool reduces the need for social services later in life?
Evaluate on a TI 83 calculator
arrow_forward
A physical education director claims by taking a special vitamin, a weight lifter can increase his strength. Eight athletes are selected and given a test of strength, using the standard bench press. After 2 weeks of regular training, supplemented with the vitamin, they are tested again. Test the effectiveness of the vitamin regiment at = 0.05
Athlete 12345678
Before 210 230 182 205 262 253 219 216
After 219 236 179 204 270 250 222 216
arrow_forward
Since muscle tension in the head region has been associated with tension headaches, a researcher reasoned that if the muscle tension could be changed, perhaps the headaches would also be changed. The researcher designed an experiment in which nine subjects with tension headaches participated. The subjects kept daily logs of the number of headaches they experienced during a 2-week baseline period. Then the researcher trained them to change their muscle tension in the head region, using a biofeedback device. For this experiment, the biofeedback device was connected to a muscle in the forehead region. The device indicated the subject's amount of tension in the muscle to which it was attached and helped them achieve low tension levels. After 6 weeks of training, during which the subjects became successful at maintaining low muscle tension, they again kept a 2-week log of the number of headaches experienced. The following are the number of headaches recorded during each 2-week period.…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Related Questions
- The National Electronic Injury Surveillance System tracks injuries reported from hospital admissions across the United States (Consumer Product Safety Commission 2018). For the data in 2017, we extracted all incidences of hand injuries that referenced punching a wall. There were 1843 such cases. The surveillance system also records some of the properties of the patients, including gender. Of all cases where a person was admitted to a hospital for injuries from punching a wall, 1352 were recorded as male and 491 were recorded as female. a. Do an appropriate hypothesis test to ask whether the proportion of males among wall-punchers is 50%.arrow_forwardA study conducted at the University of Denver investigated whether babies take longer to learn to crawl in cold months, when they are often bundled in clothes that restrict their movement, than in warmer months. Infants born during the study year were split into twelve groups, one for each birth month. We consider the average crawling age of babies in each group against the average temperature when the babies are six months old (that's when babies often begin trying to crawl). Temperature is measured in degrees Fahrenheit and age is measured in weeks. 34 33 32 31 30- 29 30 40 50 60 70 Temperature (F) a) Describe the relationship between temperature and crawling age. Choose all answers that apply. There is strong, negative, linear relationship between termperature and crawling age nThere is a somewhat moderate, negative, linear relationship between temperature and crawling age nThere is a moderate, positive, linear relationship between the temperature and crawling age The point at the…arrow_forwardAn aircraft emergency locator transmitter (ELT) is a device designed to transmit a signal in the case of a crash. The Altigauge Manufacturing Company makes 80% of the ELTS, the Bryant Company makes 15% of them, and the Chartair Company makes the other 5%. The ELTS made by Altigauge have a 4% rate of defects, the Bryant ELTS have a 6% rate of defects, and the Chartair ELTS have a 9% rate of defects (which helps to explain why Chartair has the lowest market share). a. If an ELT is randomly selected from the general population of all ELTS, find the probability that it was made by the Altigauge Manufacturing Company. b. If a randomly selected ELT is then tested and is found to be defective, find the probability that it was made by the Altigauge Manufacturing Company. c. What is the probablity that a randomly selected ELT is defective?arrow_forward
- An aircraft emergency locator transmitter (ELT) is a device designed to transmit a signal in the case of a crash. The Altigauge Manufacturing Company makes 80% of the ELTS, the Bryant Company makes 15% of them, and the Chartair Company makes the other 5%. The ELTS made by Altigauge have a 4% rate of defects, the Bryant ELTS have a 6% rate of defects, and the Chartair ELTS have a 9% rate of defects (which helps to explain why Chartair has the lowest market share). i) If an ELT is randomly selected from the general population of all ELTS, find the probability that it was made by the Altigauge Manufacturing Company. If a randomly selected ELT is then tested and is found to be ii) defective, find the probability that it was made by the Altigauge Manufacturing Company.arrow_forwardCintas has installed three smoke detectors in its stockroom. The installer asserts that each detector is 90% likely to detect a fire within 30 seconds of ignition. Assuming the three detectors function independently, how likely is it that a fire will be detected within 30 seconds?arrow_forwardBurning fuels in power plants and motor vehicles emits carbon dioxide (CO2), which contributes to global warming. The CO2 emissions (metric tons per capita) for countries varies from 0.02 in Burundi to 44.02 in Qatar. Although the data set includes 214 countries, the CO2 emissions of 15 countries are not available on the World Bank database. The data set is too large to display but the data for the first five countries is given. Use the full data set with data on the 214 countries to answer the questions. To access the complete data set, click the link for your preferred software format: Excel Minitab JMP SPSS TI R Mac-TXT PC-TXT CSV Crunchlt! Country CO2 Emissions (Metric Tons per Capita) Aruba 23.92 Andorra 5.97 Afghanistan 0.43 Angola 1.35 Albania 1.61 Find the mean and the median for the full data set. Round your answers to three decimal places. The mean for these data is tons per person The median for these data is tons per personarrow_forward
- A study was performed to evaluate the support for increasing the speed limit between the residents. A random sample of 500 residents of Marietta - Georgia found that 385 were in favor of increasing the highway speed limit to 75 mph, while another sample of 400 residents of Kennesaw - Georgia found that 267 were in favor of the increased speed limit. Do these data indicate that there is a difference in the support for in increasing the speed limit between the residents of the two cities? Use a = 0.05. (a) Test the hypothesis Ho: P1 = p2 versus H1: P1 # P2. What is zo? (b) Is it reasonable to conclude that there is a difference in the support for increasing the speed limit between the residents of the two cities?arrow_forwardA recent drug survey showed an increase in the use of drugs and alcohol among local high school seniors as compared to the national percent. Suppose that a survey of 100 local seniors and 100 national seniors is conducted to see if the proportion of drug and alcohol use is higher locally than nationally. Locally, 65 seniors reported using drugs or alcohol within the past month, while 60 national seniors reported using them.arrow_forwardThe Virginia Department of Health publishes COVID-19 vaccination data on their website. As of 10/5/2021, 60.6% of the population of Virginia is fully vaccinated. This rate varies drastically from county to county. Specifically, Fairfax County’s full vaccination rate is 74% and Lee County’s full vaccination rate is 40%. A researcher took a random sample of 14 individuals from Fairfax County and another random sample of 14 individuals from Lee County and asked them whether they could verify that they are fully vaccinated. Each sample was selected in a single day. 1. Calculate the mean and standard deviation of the number of individuals from Fairfax County and Lee County in this sample who are fully vaccinated. Show your work using the binomial mean and binomial standard deviation formulas and provide your two means and two standard deviations in your document. Round your answers to two decimal places. (It is not necessary to use StatCrunch for this part.) 2. Calculate the probability…arrow_forward
- According to scientists, the cockroach has had 300 million years to develop a resistance to destruction. In a study conducted by researchers, 6 comma 0006,000 roaches (the expected number in a roach-infested house) were released in the test kitchen. One week later, the kitchen was fumigated and 18 comma 10718,107 dead roaches were counted, a gain of 12 comma 10712,107 roaches for the 1-week period. Assume that none of the original roaches died during the 1-week period and that the standard deviation of x, the number of roaches produced per roach in a 1-week period, is 1.61.6. Use the number of roaches produced by the sample of 6 comma 0006,000 roaches to find a 9595% confidence interval for the mean number of roaches produced per week for each roach in a typical roach-infested house. Find a 95% confidence interval for the mean number of roaches produced per week for each roach in a typical roach-infested house.arrow_forwardA study shows that 80% of the population was vaccinated against the Venusian flu but 2% of the vaccinated population got the flu anyway. If 10% of the total population got this flu, what percent of the population either got the vaccine or got the disease?arrow_forwardThe data for this exercise was obtained from https://www.currentresults.com/Weather/Florida/yearly-florida-rainfall.php 2 . Tourists often hear about the wonderful, warm Florida weather; they live in blissful ignorance of the freezes experienced in the northern parts of the state. A tourism organization wants to open up the entire state to tourists. They know that not everyone is drawn to hot, sunny beaches, so they want to advertise the advantages of visiting other parts of the state. One of the first things they need to do is educate potential tourists about the weather. And part of that involves informing them about the average rainfall across the state. Your task is to help the tourism organization figure out what the average rainfall in Florida is like. Rainfall data is provided below. The table below gives the typical yearly rainfall in some parts of Florida. Place Rainfall (inches per year) Monticello 56.8 Niceville 71.0 Tampa 46.3 Lakeland 54.8 St. Augustine Lake City 49.0 52.6…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Mathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,

Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,