Step 1: Write SQL to List the information delivered (PO number, order date, vendor ID & name, product ID & name, Product quantity) of transaction records, sorted by order date?
Step 2: Write SQL For orders that were placed between 9/1/2016 and 9/30/2016, list (product IDs, product names, order dates, PO numbers) sort by order date
Step 3: Write SQL and find
In the month of August, which vendor received the smallest order for a product in terms of dollars?
Hint the date returned should have these headings:
vendor_id, vendor_name, order_date, po_number, line_number, Product_ID, total_cost
In: Computer Science
View as TextDownload
/ 3
1
Math 200
Assignment 1
Name:___________________________
1.
A researcher is interested in finding the mean and median length of all walleye in a lake. A Sample of 300
walleye was caught and their lengths were recorded. The sample mean and median lengths were found to be
28 inches and 33 inches.
a.
What is the experimental unit in this experiment?
b.
What is the population in this experiment?
c.
What are the parameters considered in this experiment?
d.
What are the statistics in this experiment?
2.
A pollster is interested in the proportion of Minnesota residents who favor a tax increase for people earning
more than 250,000 a year. In a random sample of 200 Minnesota residents 128 favor the tax increase.
a.
What is the individual unit in this experiment?
b.
What is the population in this experiment?
c.
What is a parameters considered in this experiment?
d.
What is a statistics in this experiment?
e.
What variables should pollster collect in this experiment?
Data in the assignment
is hypothetical and should not be used as facts.
2
Math 200
Assignment 1
Name:___________________________
3.
A sociologist is interested in the opinion of Minnesota teachers on the recent labor union law passed by
Wisconsin lawmakers.
a.
What is the experimental unit?
b.
What is the population?
c.
What are the variables relevant to this study? Classify them as continuous, discrete, nominal, or
ordinal.
d.
Explain how you would select a sample for this study. Explain pros and cons of your method.
4.
Which sampling technique you would use for each of the following experiments. Explain your reasoning.
a.
A scientist is interested in the amount of lead in drinking water of a small town.
b.
A botanist is interested in the height of pine trees in a large forest.
c.
A sociologist wants to estimate the number of people in Minnesota without health insurance.
d.
A student wants to estimate the speed of vehicles passing by a mile post in a rural road for an
assignment due next day.
e.
A teacher is interested in NWEA math scores of Grade 10 students in Minnesota\
Data in the assignment
is hypothetical and should not be used as facts.
3
Math 200
Assignment 1
Name:___________________________
5.
In each of the following, identify the variables are categorical nominal, or categorical ordinal, or numerical
discrete or numerical continuous.
a.
Political affiliation of a voter
b.
Crime rate in a city.
c.
Number of vehicles parked illegally.
d.
Time zone of a person’s hometown.
e.
Height of a pine tree.
f.
Speed of a vehicle passing through a traffic light.
g.
Pant size of a randomly selected male as S, M, L, XL, XXL.
h.
Apartment number of a resident living in a large apartment complex.
6.
A researcher wants to study the health of deer population in a forest. Give two categorical variables, a
numerical discrete variable, and a numerical continuous variable that should be measured.
7.
The number of activities can be performed by group of kindergartners as follows:
3
1
4
3
4
6
4
5
3
4
4
Draw a dot plot.
Data in the assignment
is hypothetical and should not be used as facts.
In: Statistics and Probability
I. Consider the condition (x == y). How is this handled if x and
y are primitive types? How is this handled if x and y are
objects?
II. For the program to get a name interactively a Scanner object
must be instantiated. Write the Java statement to do this.
III. Write a statement using a Scanner method to get the first name
interactively.
IV. Write a method to extract the initial (first letter) from the
first name.
V. Write a statement using a method to guarantee that the initial
(first letter) will be a capital letter.
Java programming
In: Computer Science
Download this assignment in word and type answers directly below the questions.
1. Name the federal agency charged with enforcement of employment discrimination.
2.Name the California agency charged with enforcement of employment discrimination.
3.What is disparate-impact discrimination?
4.What is disparate-treatment discrimination?
5.What is the difference between disparate-impact discrimination v. disparate -treatment discrimination?
6.Name the laws and the people that they protect (See EEOC presentation).
7. What are some of the defenses to alleged acts of discrimination.
In: Operations Management
Cruz Company has gathered the information needed to complete its Form 941 for the quarter ended September 30, 2019.
Using the information presented below, complete Part 1 of Form 941, rounding to the nearest cent.
Hint: Line 7 instructions. Fill in Form 941 through line 6, then fill in Part 2, line 16. Take that information and fill in line 13. Lines 12 and 13 must equal. If the amounts are not the same, correct by entering amount to make equal on line 7. Line 7 differences are caused by how calculations are made on Form 941 and the amounts withheld from employee's earning plus the employer's payroll tax amounts each pay.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Create a C Program that reads a file and replaces every other letter with an asterisk. The first integer 'num' is the number of lines.
Include an "Error" Message and exit the program if:
The wrong name for the input/output file is
given
The input/output file can not be opened
input.txt
7
Never
Have
We
Ever
Played
A
Game
output.txt
7
N*v*r
*a*e
W*
*v*r
*l*y*d
*
G*m*
In: Computer Science
1. Interpret the results of the studies below.
a) A study was run to estimate the difference between UC students and CSU students in the proportion that work full-time. A random sample of 200 UC students had 42 that worked full-time. A random sample of 300 CSU students had 96 that worked full-time. Researchers found a 95% confidence interval of -0.187<PUC-PCSU<-0.033.
b) A study was run to determine if a new machine at a factory was less likely to produce flawed products than the old machine. A random sample of 200 products from the old machine had 11 flawed. A random sample of 200 products from the new machine had 9 flawed. Researchers set a significance level of 5% and found a p-value of 0.179.
2. Newborn males have a mean length of 49.9cm with a standard deviation of 1.9cm. Researchers plan to take a random sample of 50 newborn males. Find the shape, center, and spread for the sampling distribution.
In: Statistics and Probability
the Santa Ana winds are strong within Southern
California. what drives this phenomenon?
(use thermodynamic quantities/concepts to explain)
Physical chemistry question
In: Chemistry
A split-plot experiment was conducted in a completely randomized design with whole-plot treatments as a 2x2 factorial (factors A and B) and the subplot treatments as three levels of factor C. There are four whole-plot replicants per whole plot treatment. Assume all treatment effects were fixed and include all interactions between factors.
1. Write the linear model for the experiment. Identify each of the model effects/components and list the number of levels for each effect. Make sure to specify which effects are random and which are fixed.
2. Create the ANOVA table for the experiment, just including the name of the source, degrees of freedom, and expected mean squares
3. Write out the appropriate F-ratio for each of the treatment effects and all interactions.
In: Statistics and Probability
Abrams established a rule that relates the water-cement ratio to strength of concrete. List two additional factors that have a significant influnce on the concrete strength.
Q2. Explain does why: • The transtion zone impact more rich cementitious mixtures than lean ones.
• Air entrainment reduce the strength of moderate to high strength concrete yet may enhance the strength of low strength concrete.
• ASTM cements Type I. III, and V have different impact on early and later strength of concretes made with these cements.
• On the basis of qual workability the surface characteristics of aggregate have a limited impact on the ultimate strength of concrete.
• the surface characteristics of aggregate have a clear impact on ultimate strength of concrete on the basis of qual water content.
• The cylinder strength is higher than that of cube's.
• The aspect ratio of concrete cylinders has no impact on compressive strength obtained in compression testing machine with brush platens.
• Concrete bridges should not be subjected to stress levels higher than 0.55 of ultimate strengths.
• the maximum aggregate size of aggregate have two opposing effects on concrete strength.
In: Civil Engineering