i have several thousand lines of data that i need to generate regression slope values for. The relevant columns are "Distance" with four options, 0.25, 0.5, 1 and 2. Each of these distances has a numerical value associated with it. These groups of 4 distances are repeated 32 times in each of 9 different sampling ventures.
What i want Excel to do for me is take each of these distinct 0.25/0.5/1/2 groupings and generate a separate regression slope for each one.
How can i write that code?