The buyer ages are approximately normally distributed and the sample does not contain any outliers. Construct a 90% confidence interval for the mean age for all the real estate agent's clients who purchased investment property. ( , ) (Use ascending order. Round to one decimal place as needed.) 36 31 52 42 34 47 56 43 46 44 58 48 51 47 40 The following data represent the age (in weeks) at which babies first crawl based on a survey of 12 mothers. 5252 3030 4444 3535 4747 3737 5656 2626 5252 3535 3939 3030 0204060199502575Age (in weeks)Percent • • • A normal probability plot with bounds governed by two curves has a horizontal axis labeled "Age (in weeks)" from 0 to 60 in increments of 10 and a vertical axis labeled "Percent" from 1 to 99 with intermediate tick marks labeled 25, 50, and 75. The outer vertical tick marks are farther apart from each other than the inner vertical tick marks. There is a line, rising from left to right, which passes through the points (28, 25) and (53, 75). Twelve plotted points generally follow the pattern of the line. All of the points are between the bounds. All coordinates are approximate. 30405060 • • • A horizontal boxplot has a number line labeled from less than 30 to 60 in increments of 5 and consists of a box extending from 30 to 52 with a vertical line through the box at 40 and two horizontal lines extending from the left and right sides of the box to 26 and 56, respectively. All values are approximate. Meanequals=40.25 StDev equals=9.84 Click the icon to view the table of areas under the t-distribution. (a) Because the sample size is small, we must verify that the data come from a population that is normally distributed and that the sample size does not contain any outliers. Are the conditions for constructing a confidence interval about the mean satisfied? A. No, the sample contains an outlier. B. Yes, the population is normally distributed and the sample does not contain any outliers. Your answer is correct. C. No, the population is not normally distributed. (b) Construct a 95% confidence interval for the mean age at which a baby first crawls. Select the correct choice below and fill in any answer boxes in your choice. A. ( , ) (Use ascending order. Round to one decimal place as needed.) B. A 95% confidence interval cannot be constructed.

A computer factory is planning to change their production process. They hire 18 new employees and half of them applies the new production process while the other half applies the old procedure. The length of time in minutes required for each employee to assemble the computer is recorded at the end of the month. The resulting measurements are shown in the following table. We know that the samples are independent. Assume normally distributed assembly times and assume that the variances of the assembly times are equal for the two methods. Estimate the true mean difference (Old-New) with 90% confidence interval and decide which assembly method is better.

Procedure Measurements

Old 32 37 35 28 41 44 35 31 34

New 35 31 29 25 34 40 27 32 31

One state lottery game has contestants select 5 different numbers from 1 to 45. The prize if all numbers are matched is 2 million dollars.  The tickets are $2 each.

Please show work.

1)    How many different ticket possibilities are there? Hint: use combinations here 45 C 5.  Order of the numbers doesn't matter, just matching them, so we don't need permutations.  

2)    If a person purchases one ticket, what is the probability of winning? What is the probability of losing?

3)    Occasionally, you will hear of a group of people going in together to purchase a large amount of tickets. Suppose a group of 30 purchases 6,000 tickets.

a)    How much would each person have to contribute?

b)    What is the probability of the group winning? Losing?

4)    How much would it cost to “buy the lottery”, that is, buy a ticket to cover every possibility? Is it worth it?

5)    Create a probability distribution table for the random variable x = the amount won/lost when purchasing one ticket.

6)    In fair games, the expected value will be $0. This means that if the game is played many…many times, then one is expected to break even eventually. This is never true for Casino and Lottery games.   Find the expected value of x = the amount won/lost when purchasing one ticket.

7)    Interpret the expected value.  

8)    Fill in the following table using the expected value.

economics question

be clear show steps and solution for rating solve in 40 minutes for rating

Seven years ago a New Brunswick logging company purchased a used wood chipper for $131,000 for biomass and custom chipping. Operating and maintenance costs averaged $4,000 per year. A complete overhaul at the end of year 4 cost additional $9,000. Annual revenue from using the chipper was $20,000 per year. Calculate the annual worth of the chipper at 7% interest rate

(Note: Round your answer to 2 decimal places and do not use the $ sign in your answer)

Direction: A small data set is given below. You will run a t-test using Excel. You must provide Excel output to get full credit for this question. A medical researcher wants to determine whether a drug changes the body’s temperature. Seven test subjects are randomly selected, and the body temperature (in degrees Fahrenheit) of each is measured. The subjects are then given the drug and after 20 minutes, the body temperature of each is measured again. The results are listed below. Use significance level α = 0.05, and we assume that the body temperatures are normally distributed.

Subject 1 2 3 4 5 6 7

Initial Temperature 101.8 98.5 98.1 99.4 98.9 100.2 97.9

Second Temperature 99.2 98.4 98.2 99.0 98.6 99.7 97.8

Provide results for the following questions: 1. Which t-test you used? 2. Degrees of freedom? 3. t-statistic of the test? 4. One or two tailed hypothesis testing used? 5. p value? 6. Do you reject or fail to reject the null hypothesis? 7. At α = 0.05, is there enough evidence to conclude that the drug changes the body’s temperature? (you will make an inference about results)

The table below gives the list price and the number of bids received for five randomly selected items sold through online auctions. Using this data, consider the equation of the regression line, yˆ=b0+b1xy^=b0+b1x, for predicting the number of bids an item will receive based on the list price. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant.

Table

Copy Data

Step 3 of 6:

Substitute the values you found in steps 1 and 2 into the equation for the regression line to find the estimated linear model. According to this model, if the value of the independent variable is increased by one unit, then find the change in the dependent variable yˆy^.

Summation Table

Could you please explain step by step how to resolve this problem? thank you

Sales Territory and Salesperson Profitability Analysis

Havasu Off-Road Inc. manufactures and sells a variety of commercial vehicles in the Northeast and Southwest regions. There are two salespersons assigned to each territory. Higher commission rates go to the most experienced salespersons. The following sales statistics are available for each salesperson:

a. 1. Prepare a contribution margin by salesperson report. Compute the contribution margin ratio for each salesperson.

a. 2. Interpret the report.

Paul earns the contribution margin and has the contribution margin ratio. This is because he sells the units, has a commission rate, and sells a product mix with a manufacturing margin. Steve also sells products with a average manufacturing margin but at a commission rate. Colleen has the contribution margin ratio among the four salespersons. Although Rene has a high variable cost of goods sold and also sells products with a average sales price per unit, she has the second total contribution margin.

b. 1. Prepare a contribution margin by territory report. Compute the contribution margin for each territory as a percent, rounded to one decimal place.

b. 2. Interpret the report.

The Southwest Region has $ more sales and $ more contribution margin. In the Southwest Region, the salesperson with the highest sales unit volume, has the contribution margin ratio. The Southwest Region has the performance, even though it also has the salesperson with the contribution margin ratio. The Northeast Region contribution margin is than the Southwest Region because of the outstanding performance of .

Below is what I have to do. This is all performed in SQL. I have written a bunch of code, that I have also provided. Any help is appreciated

Exercises

Complete each of the following exercises. If you are unsure how to accomplish the task, please consult the coursework videos where there are explanations and demos.

1. Use built in SQL functions to write an SQL Select statement on fudgemart_products which derives a product_category column by extracting the last word in the product name. For example
   1. for a product named ‘Leather Jacket’ the product category would be ‘Jacket’
   2. for a product named ‘Straight Claw Hammer’ the category would be ‘Hammer’

Your select statement should include product id, product name, product category and product department.

2. Write a user defined function called f_total_vendor_sales which calculates the sum of the wholesale price * quantity of all products sold for that vendor. There should be one number associated with each vendor id, which is the input into the function. Demonstrate the function works by executing an SQL select statement over all vendors calling the function.
   
3. Write a stored procedure called p_write_vendor which when given a required vendor name, phone and optional website, will look up the vendor by name first. If the vendor exists, it will update the phone and website. If the vendor does not exist, it will add the info to the table. Write code to demonstrate the procedure works by executing the procedure twice so that it adds a new vendor and then updates that vendor’s information.
   
4. Create a view based on the logic you completed in question 1 or 2. Your SQL script should be programmed so that the entire script works every time, dropping the view if it exists, and then re-creating it.
   
5. Write a table valued function f_employee_timesheets which when provided an employee_id will output the employee id, name, department, payroll date, hourly rate on the timesheet, hours worked, and gross pay (hourly rate times hours worked).

Written Code

use fudgemart_v3
go

--Question 1
--This runs but doesn't supply correct output
select * from fudgemart_products
select right(product_name, charindex(' ', product_name)) as product_category from fudgemart_products
go

---Runs but returns NULL for product_Category
select product_id, product_name, product_department
from fudgemart_products
order by product_id
declare @product_name as varchar(20)
select right(@product_name, charindex(' ',@product_name)) as product_category

print len(@product_name)

---question 2-----

drop function dbo.f_vendor_sales
go

declare @vendor_id int
set @vendor_id = 1
select count(*) from fudgemart_products where product_vendor_id = @vendor_id
go

--Function says it is completed
create function dbo.f_total_vendor_sales(
   @vendor_id int --input
   ) returns int as
begin
   declare @count int
   set @count = (select count(*) from fudgemart_products.dbo.product_wholesale_price where product_vendor_id = @vendor_id)
   return @count --output
end
go

---When i attempt function, I get invalid object name

select product_vendor_id, product_wholesale_price,
   dbo.f_total_vendor_sales(product_vendor_id) as total_vendor_sales
   from fudgemart_products

----For question 3-------
create procedure p_write_vendor
(
   @vendor_name varchar (50),
   @vendor_phone varchar (20),
   @vendor_website varchar (100)
   ) as
if exists ( select 1 from fudgemart_vendors
               where vendor_name = @vendor_name
               or vendor_phone = @vendor_phone
               or vendor_website = @vendor_website)
   begin
       update fudgemart_vendors
       set vendor_name =@vendor_name,
           vendor_phone = @vendor_phone,
           vendor_website = @vendor_website
       where vendor_name = @vendor_name
       or vendor_phone = @vendor_phone
       or vendor_website = @vendor_website
   end
else
   begin
       insert into fudgemart_vendors values (@vendor_name, @vendor_phone, @vendor_website)
   end

Suppose the coffee industry claimed that the average adult drinks 1.7 cups of coffee per day. To test this​ claim, a random sample of 50 adults was​ selected, and their average coffee consumption was found to be 1.9 cups per day. Assume the standard deviation of daily coffee consumption per day is 0.5 cups using a significant level of 0.01

A. The​ z-test statistic is =

(round to two decimal places)

B. The critical z-score(s) are= (round to two decimal places)

(there should be two answers here one positive and one negative)

C. The p-value is=

(round to three decimal places)

(JAVA)
For your homework, I want you to create the order of your mini-programs based on how it is listed in this assignment description (i.e., Program 1 should be the first program implemented, Program 2 should be the second program, etc.). All your mini-programs are housed inside one main method. The name of your class for this homework should be called Homework3. You will be submitting that single Java file to this submission box. There are a total of two mini-programs you have to implement, and each program is worth 40 points for functioning code and correct outputs. Altogether, the programs are 80 points in total; the remaining 20 points reflect your programming style and documentation.

Program 1 - Palindrome

A palindrome is a sequence of characters that reads the same backward as forward. For example, each of the following five-digit integers is a palindrome: 12321, 55555, 45554, and 11611. Write an application that reads in a five-digit integer and determines whether it's a palindrome. If the number is not five digits long, display an error message and allow the user to enter a new value.

Sample Input
Enter a number: 11611

Sample Output
11611 is a palindrome.

Sample Input
Enter a number: 55953

Sample Output
55953 is not a palindrome.

Sample Input
Enter a number: 1151
Enter a number: 3920
Enter a number: 12321

Sample Output
12321 is a palindrome.

Sample Input
Enter a number: 116611
Enter a number: 999999
Enter a number: 99989

Sample Output
99989 is not a palindrome.

Program 2 - Printing the Decimal Equivalent of a Binary Number

Write an application that inputs an integer containing only 0s and 1s (i.e., a binary integer) and prints its decimal equivalent. [Hint: Use the remainder and division operators to pick off the binary number's, digits one at a time, from right to left. In the decimal number system, the rightmost digit has a positional value of 1 and the next digit to the left a positional value of 10, then 100, then 1000, and so on. The decimal number 234 can be interpreted as 4 * 1 + 3 * 10 + 2 * 100. In the binary number system, the rightmost digit has a positional value of 1, the next digit to the left a positional value of 2, then 4, then 8, and so on. The decimal equivalent of binary 1101 is 1* 1 + 0 * 2 + 1 * 4 + 1 * 8, 1 + 0 + 4 + 8, or 13]

Sample Input
Enter a binary number: 1101

Sample Output
13 is the decimal equivalent of 1101

Sample Input
Enter a binary number: 1000110

Sample Output
70 is the decimal equivalent of 1000110

Sample Input
Enter a binary number: 11111111

Sample Output
255 is the decimal equivalent of 11111111

Sample Input
Enter a binary number: 1001001110

Sample Output
590 is the decimal equivalent of 1001001110