Skip to main content

DSDP Arrays Lab

Week 2 Lab Ex 1

In this lab we learn about Sorting an array, using ForEach loop, and Random class:
  1. Open Visual Studio 2012
  2. Create a new project  by going to File --> New --> Project
  3. Select Visual C# --> Windows Desktop -->  Console Application
  4. In the Name field, type "W2Lab1-[Last_name]", where [Last_Name] is replaced with your last name.
  5. In the location field, give a directory location and click ok.
  6. Add code to declare and initialize an Int array that can hold 7 Integers.
  7. Using a For loop assign random numbers from the range 1 to 49 inclusive to the above array.
  8. Sort the array
  9. Using a ForEach loop display the seven numbers separated by tabs to console

Week 2 Lab Ex 2 

In this lab we learn about Linear Search and break:
  1. Add new console application project to the above solution
  2. Create an array which hold 20 random numbers in the range of 1 and 100.
  3. Using a For loop search for an integer given by user.
  4. Break out of the loop if the integer is found.

Week 2 Lab Ex 3

In this lab we learn about BinarySearch() :
  1. Add new console application project to the above solution
  2. Copy the code from Ex2
  3. Sort the array using Array.Sort()
  4. Edit to perform a binary search using Array.BinarySearch() rather than a Linear search.

Comments

Popular posts from this blog

CUMIPMT and CUMPRINC function

CUMIPMT Cumulative interest payment function allows you to calculate the interest paid for a loan or from an investment from period A to period B. When getting a loan, CUMIPMT function can be used to calculate the total amount of interest paid in the first five months or from period 12 to period 20. A period can be a month, a week or two week. Loan Amount : 350,000.00 APR: 4.5% Down payment: 0.00 Years: 25 Payment per year: 12 From the above data, we can calculate the following: No of Period: 25 × 12 = 300 Periodic Rate: 4.5/12 = 0.375% Here is how you will substitute these values into the function. = CUMIPMT (periodic rate, No of period, vehicle price, start period, end period,  ) = CUMIPMT (0.375, 300, 350000, 1, 5, 0) In an excel worksheet, we use cell address instead of actual values as shown below: Here is the formula view of the worksheet: CUMPRINC Another related function is CUMPRINC. CUMPRINC function is used to calculate cumul

Excel PMT Function

PMT function is very useful for calculating monthly payment required to payback a loan or mortgage at a fixed rate. This function require a minimum of three inputs, periodic rate, number of periods, present value or the loan amount. Here is a simple example. Home Loan: 350,000.00 Interest rate: 4.5% Number of years to repay the loan: 25 Note: To calculate monthly payment, we need to find the monthly rate and number of months as shown above. Then it is simply a matter of substituting the values into the payment function, as shown in the formula view below.

BCG's Brand Advocacy Index

The Boston Consulting Group's (BCG) Brand Advocacy Index (BAI) is a metric developed to help companies measure the degree of customer advocacy for their brands. BAI focuses on the likelihood of customers to recommend a brand to others, which is a powerful indicator of brand strength and customer loyalty. Unlike other customer satisfaction or loyalty metrics, BAI emphasizes the importance of customer referrals and word-of-mouth marketing. BAI is calculated based on a survey where customers are asked about their willingness to recommend a brand to their friends, family, or colleagues. The responses are then used to compute a score, which ranges from -100 to 100. A higher BAI score indicates that a brand has more advocates who are likely to recommend the brand to others, while a lower score suggests that the brand has fewer advocates or even a higher number of detractors. BCG's research has shown that companies with higher BAI scores tend to experience higher growth rates and bett