Question Test whether , <H2 at the a = 0.05 level of significance for the sample data shown in the accompanying table. Assume that the populations are normally distributed. Click the icon to view the data table. Determine the null and alternative hypothesis for this test. 0 Sample Data Population 2 O A. Ho:41 = H2 HH1 *H2 O B. Ho:H *12 H4:41 <H2 OC. HO:H1 H2 H1:41 = 2 OD. Ho:41 = 42 H1:47 *42 Population 1 32 103.5 12.3 114.2 13.3 Print Done Detemine the P-value for this hypothesis test. Pa (Round to three decimal places as needed.) State the appropriate conclusion. Choose the correct answer below. O A. Do not reject Ho. There is sufficient evidence at the a = 0.05 level of significance to conclude that 1 <H2 O B. Reject Ho. There is not sufficient evidence at the a= 0.05 level of significance to conclude that H1 H2 OC. Do not reject Ho. There is not sufficient evidence at the a = 0.05 level of significance to conclude that 11 <H2- OD. Reject Ho. There is sufficient evidence at the a = 0.05 level of significance to conclude that My <H2-

Using the time series data in the table, respond to the following items. Period Sales 1 $ 1,001 2 1,129 3 841 4 1,044 5 1,012 6 703 7 682 8 712 9 646 10 686 11 909 12 469 13 566 14 488 15 688 16 675 17 303 18 381 Click here for the Excel Data File d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal places.) d-2. What is the MAD? (Round your answer to 2 decimal places.) d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) e. What is the predicted annual change of industry sales? (Round your answer to 2 decimal places.) f. Predict sales for the next three periods. (Round your answers to 2 decimal places.)

P3.5 The sales revenue, food cost of sales, and guests served for a small fast- food carryout division of a restaurant for the past six months are given below. Sales Month Cost of Revenue Guests Served Sales, Food 1 2. 4 $258,200 274,800 285,600 289,400 298,300 304,600 $ 96,200 104,300 110,500 113,100 118,900 123,700 10,200 10,400 10,300 10,100 10,400 10,500 6 For each of the six months calculate average check and average costs of sales food. Using these averages, calculate an index number. Set the in- dex for month 1 at 100 and complete index numbers for the remaining five months. With the index numbers identified, convert sales revenue and cost of sales food from historic to current dollars.

A cylindrical rock sample has a length of 6 cm, a diameter of 4 cm, and a dry weight of 166.4 g. When fully saturated with an oil of density 0.85 g/cm3, the weight of this sample is 176.9 g. Assuming constant temperature, find: i) The porosity of the sample ii) The pore compressibility of the sample, given that 0.2 cm of oil leaves the sample when a pressure of 3200 psig is applied on it iii) The amount of oil that can be extracted from the sample when a pressure of 2000 psig is applied on it

2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Victory Company uses weighted average process costing. The company has two production processes. Conversion cost is added evenly throughout each process. Direct materials are added at the beginning of the first process Additional information for the first process follows Direct Materials Conversion Percent Percent Units Complete Complete Beginning work in process inventory 72, eee 100% 80% Units started this period 833,eee Units completed and transferred out 71e,eee Ending work in process inventory 195, eee 1ees 50% Beginning work in process inventory Direct materials $ 411,775 Conversion 100,938 $ 512, 713 Costs added this period Direct materials 2,755,725 Conversion 1,917,812 4,673,537 Total costs to account for $ 5,186,250 Required: 1. Compute equivalent units of production for both direct materials and conversion Equivalent Units of Production (EUP). Weighted Average Method Units % Materials EUP-Materials % Conversion EUP. Conversion Total units 2. Compute cost per equivalent unit of production for both direct materials and conversion Cost per equivalent unit of production Materials Conversion Costs Costs Total costs Equivalent units of production (from part 1) Cost per equivalent unit of production EUP EUP 0 0 3. Assign costs to the department's output-specifically, to the units transferred out and to the units in ending work in process Inventory (Round "Cost per EUP" to 2 decimal places.) EUP Cost per EUP Total cost Cost assignment-Weighted average Completed and transferred out Direct materials Conversion Total completed and transferred out Ending work in process Direct materials Conversion Total ending work in process Total costs accounted for $ 0 0.00 $ 0.00 S 0

Help in SQL.. please take your time 3.12 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: - ID - integer, primary key RegisteredName - variable-length string 2. Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the Lesson Schedule table with columns: • HorselD-integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references HorseID) • StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) • LessonDate Time - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in Lesson Schedule automatically. 387240.1399152.qx3zay? LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse ( 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4. PRIMARY KEY (ID) 5); 7 CREATE TABLE Student ( 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 LastName VARCHAR(30), 11 PRIMARY KEY (ID) 12 ); 13 If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. SB/270.7399152 gy LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse 2 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4 PRIMARY KEY (ID) 5); 6 7 CREATE TABLE Student 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 Last Name VARCHAR(30), 11 PRIMARY KEY (ID 12); 13 14 -- Your SQL statements go here 15 16 17 Develop mode Submit mode Explore the database and run your program as often as you'd like, before submitting for grading. Click Run program and observe the program's output in the second box. Main.sql Run program Output (shown below) (Your program) Program output displayed here Coding trail of your work What is this? History of your effort will appear here once you begin working on this zylab.