Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can I just have the process for how to do those questions? because the data is too big, i can not post all Refer to
can I just have the process for how to do those questions? because the data is too big, i can not post all
Refer to the worksheet named SOFTWARE. This worksheet provides information about 2000 software programs (rows 2-2001, each row is a different software program). Some rows are hidden to enable you to see the first and last rows easily. Column A contains an ID number for each software program. The remaining columns describe each program in terms of lines of code (total, not per procedure), number of users, and so on. 9 Considering all 2000 software programs in the data set (this refers to all 2000 rows, each row is a separate software program), what is the total number of lines of code? 10 How many of the programs (each row is a separate program) were developed during the year 2001? 11 What is the average number of users of programs written in Pascal? 12. Calculate and consider the lines-of-code-per-procedure (Lines-of-Code / Procedure). Across all programs in the data set, what is the range (difference between highest and lowest) of the calculated values for the lines-of-code-per-procedure? 13. Do any programs appear in the worksheet that were written in HTML during 1999, have 15 or more users, and have less than 10 procedures and at least 300 lines of code? If so, provide the ID numbers of programs that have these characteristics. D E F G Lines of Number of Number of Year Lines of Code Code Procedures Users Developed Per Procedure 731 5 15 1999 380 9 4 1998 718 27 2 2001 662 9 9 1998 313 10 3 1999 691 29 7 1997 849 24 18 1997 957 10 5 1997 922 29 17 1999 288 22 7 1997 B ID Program Number Language 2 1 Html 3 2 Pascal 4. 3 Html 5 4 Html 6 5 Cobol 7 Cobol 1998 1997 Fortran 1999 1998 Pascal 2000 1999 C++ 2001 2000 C++ 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started