A simple random sample of 30 households was selected from a particular neighborhood. The number of cars for each household is shown below. Construct the 98% confidence interval estimate of the population mean.

2 0 1 2 3 2 1 0 1 4

1 3 2 0 1 1 2 3 1 2

1 0 0 5 0 2 2 1 0 2

A) 1.0 cars < μ < 2.0 cars

B) 0.9 cars < μ < 2.1 cars

C) 1.3 cars < μ < 1.7 cars

D) 1.5 cars < μ < 2.0 cars

For this lab, you will work with two-dimensional lists in Python. Do the following:

1. Write a function that returns the sum of all the elements in a specified column in a matrix using the following header:

   def sumColumn(matrix, columnIndex)

2. Write a function display() that displays the elements in a matrix row by row, where the values in each row are displayed on a separate line. Use a single space to separate different values. Sample output from this function when it is called on a 3 X 4 matrix is as follows:

   2.5 3.0 4.0 1.5
   1.5 4.0 2.0 7.5
   3.5 1.0 1.0 2.5
   

3. Given this partial code

   def getMatrix(numRows, numColumns):
       '''returns a matrix with the specified number of rows and columns'''
       m = [] # the 2D list (i.e., matrix), initially empty
       for row in range(numRows):
           matrix_dimensions_string = str(numRows) + "-by-" + str(numColumns)
           line = input("Enter a " + matrix_dimensions_string + " matrix row for row " + str(row) + ": ")
       
           
       return m    

   write a function called getMatrix(numRows, numColumns) that returns a matrix with numRows rows and numColumns columns. The function reads the values of the matrix from the user on a row by row basis. The values of each row must be entered on one line using a space to separate the values. Use loops in your solution. A sample run of this function when it is caled as getMatrix(3, 4) to return a 3 by 4 matrix is as follows. Values shown in red are entered by the user:

   Enter a 3-by-4 matrix row for row 0: 2.5 3 4 1.5
   Enter a 3-by-4 matrix row for row 1: 1.5 4 2 7.5
   Enter a 3-by-4 matrix row for row 2: 3.5 1 1 2.5
   

Use the following function to test your code:

def main():
    m = getMatrix(3, 4)
    print("\nThe matrix is")
    display(m)

    print()
    for col in range(len(m[0])):
        print("Sum of elements for column %d is %.2f" % (col, sumColumn(m,col)))          

main()

A sample program run is as follows:

Enter a 3-by-4 matrix row for row 0: 1 22 3.7869 8
Enter a 3-by-4 matrix row for row 1: 4 5.6543 3 3
Enter a 3-by-4 matrix row for row 2: 1 1 1 1

The matrix is
1.0 22.0 3.7869 8.0 
4.0 5.6543 3.0 3.0 
1.0 1.0 1.0 1.0 

Sum of elements for column 0 is 6.00
Sum of elements for column 1 is 28.65
Sum of elements for column 2 is 7.79
Sum of elements for column 3 is 12.00

The format of the input and output of your program must be as in the sample run.

You first need to compute the demand function associated with the data set and use that demand function to compute the optimal price for the product. You can use 20% of the average price as the cost of the product.

please show excel work

A researcher is studying the effectiveness of different treatment options for jail inmates with mental illnesses. The researcher creates four groups: therapy plus medication; therapy alone; medication alone; and a control group (no intervention). The outcome measure is the number of disciplinary infractions each person commits within the 6 months following the start of the experiment. The data are displayed in the table. Using an alpha of .05, conduct a 5-step ANOVA hypothesis test to find out if there are differences between groups. If appropriate, calculate and interpret omega-squared.

The 5 step process must be shown.

Please answer the following questions:

1.) The Taxi Co. is evaluating a project with the following cash flows:

Year:Cash Flow

0:-20,400

1:6100

2:5200

3:7950

4:5400

5:-3700

Should this project be accepted based on the PI if the discount rate is 8 percent?

2.) A firm evaluates all of its projects by applying the IRR rule. If the required return is 18 percent, should the firm accept the following project?

Year : Cash Flow

0 : -$105,600

1 : $29,500

2 : $34,200

3 : $6,750

4 : $15,320

5 : $25,670

3.) Consider the following cash flows. If the discount rate is 12 percent, should we accept this project based on the MIRR rule?

Year : Cash Flow

0: -13,024

1: 17,172

2: -36,420

3: 34,200

4: -15,000

5: 8,500

6: 11,300

7: -6820

** Please show steps in financial calculator form. Thank you!

PYTHON

Search for an element in a 2D sorted matrix using the binary search technique. Your code should run in O(m + n) where m is the number of rows and n is the number of columns
The python file should have a function named binarysearch

The function should take two arguments. The first argument of the function will be the element to search for. Second argument of the function will be the matrix as a List[List].
The function should return the row and column of the matrix if the element is found. Use a tuple to return the row and column. Return "Not Found" if the element is not found.

Sample values for input and output :

Sample Input:
Case 1: binarysearch(4, [[1, 2, 3],[4, 5, 6],[7, 8, 9]] )
Case 2: binarysearch(10,[[2, 3, 4],[5, 7, 9],[11, 12, 13],[20, 22, 24]]

Sample Output :
Case 1: (1 , 0)
Case 2: Not Found

2. Enter the following record into the Inventory table using data listed below:

3. The Chevrolet Lumina was sold on 5/20/08 by Bauer for $9,300. Update the INVENTORY table and modify date sold, selling price, and repnumber.
4. Write SQL statements to query the following information
   1. All vehicles available for sale with a selling price less than $6,000, sorted by cost in descending order.
   2. All vehicles sold, grouped by Sales Rep.
   3. All vehicles made by Ford and Toyota.

8. Find the solutions of the following initial value problems

• x ''' + 6x '' + 12x ' + 8x = 0, x(1) = −2, x' (1) = x '' (1) = 0

• x ^(5) + 4x^ (4) + 5x^ (3) = 0, x(0) = x ' (0) = x '' (0) = 1, x^(3) (0) = x^ (4) (0) =0

The continuous random variable X has the following distribution: pX[x] = kx√(1 + 2x) (Hint: There is 1 + 2x in the square root.) for 1 ≤ x ≤ 4.

1-Determine k.

2-Determine the CDF of X.

3-Determine the mean of X.

4-Calculate P(0.2 < X < 0.5) only by using CDF of X.