Master College Concepts with Expert Q&A and Solutions

A professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 10 students who took the course last quarter are given below.Student No. Hours Spent Studying Total Points Earned1 25 182 10 133 70 534 40 435 85 686 45 287 70 688 60 589 35 2310 55 43Simple Regression - POINTS vs. HOURSDependent variable: POINTSIndependent variable: HOURSLinear model: Y=a +b*XCoefficientsLeast Squares Standard TParameter Estimate Error Statistics P-ValueIntercept 0.437798 5.9182 0.073948 o.9428Slope 0.829539 0.109474 7.57748 0.0001Analysis of VarianceSource Sum of Squares Df Mean Square F-Ratio P-ValueModel 3249.72 1 3249.72 57.42 0.0001Residual 452.779 8 56.5974 Total (Corr.) 3702.5 9The following questions are based on the information above.1) Write down the estimated regression equation that could be used to estimate the total points earned in the course given the hours spent studying.2) At the 0.05 level of significance, does hours spent studying have a significant effect on the total points earned in this course?3) Find the standard error of the estimate.4) Use the estimated regression to predict the points of a student who spent 50 hours studying for this course.5) If a student spent 120 hours studying for this course, would you feel comfortable to use your estimated regression equation to predict his points? Why?6) What's the R-squared?7) Do you believe your estimated regression equation would provide a good prediction of the points? Use R-squared from Question 8 to support your answer.
You are asked to design a data model for The Wagging Tail, an online store that sells products for dogs, e.g. dog collars, dog food, dog toys, dog treats, etc. You want to keep track of three entities: (1) the products that the store sells, (2) customers who purchase the products, and (3) the orders that are made on the website.Draw an ERD diagram and use the following information to help guide your drawing:The database should keep track of all products that the store offers for saleThe database should keep track of all customers who have registered with the store websiteThe database should keep track of all orders placed on the websiteAt most only a single customer can be related to any single orderA customer can place multiple orders with the website Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key.An order must consist of at least one product, and may consist of multiple productsYou wish to keep track of the cost of the product to the store, and the price that the store sells a product to the customerYou wish to be able to contact customers via phone and emailYou wish to be able to determine when is the busiest time of year for your website according to number of orders placedYour drawing should include the following: 1. The entities you wish to model 2. The required/important attributes for each entity (refer to these instructions for guidance on what is required/important) 3. The relationships between the entities 4. The correct MAX and MIN Cardinalities for each relationship (remember for each relationship, or line, there are MAX/MIN cardinalities on each side of the relationship)
Learn by DoingHere are the directions, grading rubric, and definition of high-quality feedback for the Learn by Doing discussion board exercises.ContextStudents researching backpack weights gathered data from 45 elementary school children in the 3rd and 5th grades. The variable is "percent of body weight carried in the school backpack." So a child who weighs 60 pounds and carries 9 pounds has a variable value of 15% (9 60 = 0.15 = 15%). The American Chiropractic Association (ACA) recommends that children carry no more than 10% of their body weight.PromptWhen we analyze backpack weight as a percentage of body weight, how do 3rd and 5th graders compare? Are children in this study following the ACA recommendation?% of body weight carried in backpack Thirdgraders Fifthgraders0-5% 1 15-10% 6 610-15% 11 415-20% 3 720-25% 0 125-30% 0 230-35% 0 1Totals 21 22Note: Left-hand end-points are included in each bin. So the 2nd bin contains students carrying 5% of their body weight.GradingTo view the grading rubric for this discussion board, click on menu icon (three vertical dots) and then select show rubric. Please note, if viewing the course via the Canvas mobile app the rubric does not appear on this page.Tips for SuccessTo post your initial post, click the "reply" button at the top of the introduction thread below.You are required to reply to two of your peers in this discussion; don't forget to complete this requirement of the activity or you will lose points. Provide high-quality feedback to your peers.
When the accounts of Metlock Inc. are examined, the adjusting data listed below are uncovered on December 31, the end of an annual fiscal period.1. The prepaid insurance account shows a debit of $6,288, representing the cost of a 2-year fire insurance policy dated August 1 of the current year.2. On November 1, Rent Revenue was credited for $1,662, representing revenue from a subrental for a 3-month period beginning on that date.3. Purchase of advertising materials for $730 during the year was recorded in the Advertising Expense account. On December 31, advertising materials of $308 are on hand. 4. Interest of $722 has accrued on notes payable.Prepare the following in general journal form. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter 0 for the amounts.) (a) The adjusting entry for each item. No. Account Titles and Explanation Debit Credit1. enter an account title for the adjusting entry I enter a debit amount enter a credit amount enter an account title for the adjusting entry enter a debit amount enter a credit amount2. enter an account title for the adjusting entry enter a debit amount enter a credit amount enter an account title for the adjusting entry enter a debit amount enter a credit amount3. enter an account title for the adjusting entry enter a debit amount enter a credit amount enter an account title for the adjusting entry enter a debit amount enter a credit amount4. enter an account title for the adjusting entry enter a debit amount enter a credit amount enter an account title for the adjusting entry enter a debit amount enter a credit amount(b) The reversing entry for each item where appropriate. No. Account Titles and Explanation Debit Credit1. enter an account title for the reversing entry enter a debit amount enter a credit amount enter an account title for the reversing entry enter a debit amount enter a credit amount2. enter an account title for the reversing entry enter a debit amount enter a credit amount enter an account title for the reversing entry enter a debit amount enter a credit amount3. enter an account title for the reversing entry enter a debit amount enter a credit amount enter an account title for the reversing entry enter a debit amount enter a credit amount4. enter an account title for the reversing entry enter a debit amount enter a credit amount enter an account title for the reversing entry enter a debit amount enter a credit amount