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

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.

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

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.

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*

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<P_UC-P_CSU<-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.

the Santa Ana winds are strong within Southern California. what drives this phenomenon?
(use thermodynamic quantities/concepts to explain)
Physical chemistry question

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.

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.

1. If someone has a calcium deficiency, how will that effect their muscle for generation? Why would it effect  

2. How does optimal length effect the cross bridges? What happens at greater the optimal length and what happens at less the optimal length?