Use an Excel function to find: Note: No need to use Excel TABLES to answer these questions! 6. The average viewer rating of all shows watched. 7. Out of all of the shows watched, what is the earliest airing year

Answers

Answer 1

Answer:

Use the average function for viewer ratings

Use the min function for the earliest airing year

Explanation:

The average function gives the minimum value in a set of data

The min function gives the lowest value in a set of data


Related Questions

Other Questions
The January 1, Year 1 trial balance for the Tyrell Company is found on the trial balance tab. The beginning balances are assumed. Tyrell Co. entered into the following transactions involving short-term liabilities in Year 1 and Year 2.Year 1 Apr. 20 Purchased $40,250 of merchandise on credit from Locust, terms n/30. May 19 Replaced the April 20 account payable to Locust with a 90-day, 10%, $35,000 note payable along with paying $5,250 in cash. July 8 Borrowed $80,000 cash from NBR Bank by signing a 120-day, 9%, $80,000 note payable. Aug. 17 Paid the amount due on the note to Locust at the maturity date. Nov. 5 Paid the amount due on the note to NBR Bank at the maturity date. Nov. 28 Borrowed $42,000 cash from Fargo Bank by signing a 60-day, 8%, $42,000 note payable. Dec. 31 Recorded an adjusting entry for accrued interest on the note to Fargo Bank. Year 2 Jan. 27 Paid the amount due on the note to Fargo Bank at the maturity date.Requirement General General Trial Schedule of Calculation of Year 2 Journal Ledger Balance Payables Interest Payment1. General Journal tab- Prepare the 2016 journal entries related to the notes and accounts payable of Tyrell Co 2. Calculation of interest tab - Use the interest formula (P x Rx T) to verify the amount of interest recorded in your entries. Verify that total interest expense agrees with the trial balance.3. Year 2 payment tab - Prepare the January 27, 2017 entry to record the re-payment of the note at maturity A right triangle ABC has sides /AB/ =9cm, /BC/=12cm find /AC/ and angles ACB and ABC if angle BAC= 90 whats the answer??? John wants to invest in a simple intereset savings account The intereset rate on this account is 0.7%. The account balance y can be modeled by the following linear equation y=150,000+150,000(0.007)x where x represents the time (in years) that john leaves her money in the account what is johns initial investment? Marx and engels believed that a communist revolution would defeat capitalism and that the revolution would be led by On 12/31/X4, Zoom, LLC, reported a $55,500 loss on its books. The items included in the loss computation were $27,000 in sales revenue, $12,000 in qualified dividends, $19,000 in cost of goods sold, $47,000 in charitable contributions, $17,000 in employee wages, and $11,500 of rent expense. How much ordinary business income (loss) will Zoom report on its X4 return An 8-sided fair die is rolled twice and the product of the two numbers obtained when the die is rolled two times is calculated. Draw the possibility diagram of the product of the two numbers appearing on the die in each throw Use the possibility diagram to calculate the probability that the product of the two numbers is A prime number Not a perfect square A multiple of 5 Less than or equal to 21 Divisible by 4 or 6 In a certain community, eight percent of all adults over age 50 have diabetes. If a health service in this community correctly diagnosis 95% of all persons with diabetes as having the disease and incorrectly diagnoses ten percent of all persons without diabetes as having the disease, find the probabilities that: Correctly order the production and transport of sperm through the male reproductive system. Semen is released from the penis. Sperm are produced in the testes. Sperm leave the testes through the semen duct. In the semen duct, fluids from the glands are added to the sperm. Solve for x12:15 = x 536060 Which graph represents the solution set of the inequality. 5a+18 Solve for r in the triangle. Round your answer to the nearest tenth. please need help I will be MARKING as BRIANILIST. thank you so much. HELP ME PLEASE! So Im working on this practice page before I start my quiz but I dont understand these two problems, I was hoping someone would help me. Complete the statement about the types of violence to which children are exposed. Children are exposed to violence through aggressive acts in the home called ------------ violence, perpetrated by family members against other family members. These acts can include physical and sexual abuse, intimidation, verbal abuse, and neglect. ------------- violence includes conventional crimes such as robbery, murder, threats, hate crimes, and child maltreatment. can someone help fill in the gaps in the table and calculate an estimate for the mean How many solutions does 6-3x=4-x-3-2x have? A spherical balloon is made from a material whose mass is 4.30 kg. The thickness of the material is negligible compared to the 1.54-m radius of the balloon. The balloon is filled with helium (He) at a temperature of 289 K and just floats in air, neither rising nor falling. The density of the surrounding air is 1.19 kg/m3. Find the absolute pressure of the helium gas. MY LAST 2 QUESTION WILL FOREVER BE GRATEFUL PLS HELP WILL GIVE BRANLIEST!! AT LEAST TAKE A LOOK!!!! PLS I AM BEGGING!!! 1. Which statement can be made based on the diagram below? IMAGE BELOW A) m1 + m2 = 180 B) m2 + m3 = 180 C) 2= 3 D) 3=4 4. What is the difference between a formal and informal proof? A) A formal proof provides the reasons for steps, whereas an informal proof does not. B) A formal proof uses a table or a list of steps, whereas an informal proof uses paragraphs. C) A formal proof is much shorter, whereas an informal proof is longer. D) A formal proof uses equations, whereas an informal proof only uses text. Which inequality is represented by this graph?