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).
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
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
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
Sophomore, junior, and senior students at a high school will be surveyed regarding a potential increase in the extracurricular student activities fee. There are three possible responses to the survey question - agree with the increase, do not agree with the increase, or no opinion. A chi-square test will be conducted to determine whether the response to this question is independent of the class in which the student is a member. How many degrees of freedom should the chi-square test have?
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
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 report by the New York Times in 2022 indicated that, on average, a married woman in the United States goes out with her female friends an average of 5.7 times peryear. A student at Century College conducts a study of her own by randomly surveying married women in White Bear Lake and obtained this data for the number of times in a year:
3 1 1 3 7 2 9 4
6 4 3 8 0 5 6 4
0 1 3 0
Use your calculator to determine the mean and standard deviation for this sample. Then, at the level of significance, Test the claim that married women in White Bear Lake, on average, go out with their female friends less than the overall national average. Be complete, show every step including hypotheses, a labelled graph, and clearly state the final result. Do not use the P-value method. Explain what the final result means in the context of this problem.
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
In various places in this module, data on the silver content of coins minted in the reign of the
twelfth-century Byzantine king Manuel I Comnenus have been considered. The dataset includes,
among others, the values of the silver content of nine coins from the first coinage (variable Coin1)
and fourth coinage (variable Coin4) which was produced a number of years later. it was argued that
the silver contents in both the first and the fourth coinages can be assumed to be normally
distributed. The question of interest is whether there were differences in the silver content of coins
minted early and late in Manuel's reign. You are about to investigate this question using a two-
sample t-interval.
COINS (21.MWX
Two-Sample T-Test and CI: Coin1, Coin4
A COINS (2)MWX
Two-Sample T-Test and Cl: Coin4, Coin1
Method
Method
mean of Coin1
Pa mean of Coind
Difference u-
4 mean of Coin4
z mean of Coint
Difference: - Vz
Equal variances ore assumed for this analysis
Equal variances ore assumed for this…
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
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). 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
- 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_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_forwardSophomore, junior, and senior students at a high school will be surveyed regarding a potential increase in the extracurricular student activities fee. There are three possible responses to the survey question - agree with the increase, do not agree with the increase, or no opinion. A chi-square test will be conducted to determine whether the response to this question is independent of the class in which the student is a member. How many degrees of freedom should the chi-square test have?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_forwardAlthough 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 aarrow_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,